Forum Discussion
Generate Date table in Direct Query Mode
Hello all, I have a question related to DirectQuery mode. I want to return a date table eg. having 2 column StartDate,EndDate that I would be joining to my fact table. Any suggestion if you want to...
Anonymous , You can create a local date table in direct Query, That will convert it into mixed mode
Date = Calendar(Min(Table1[Date]), Max(Table1[Date]))
refer if needed
https://www.youtube.com/watch?v=24arfrD3Qzk&list=PLPaNVDMhUXGbKatyDdOhGbTL3xW2Xy6pA&index=6
https://www.youtube.com/watch?v=cQfJ0GmQ5os&list=PLPaNVDMhUXGbKatyDdOhGbTL3xW2Xy6pA&index=7
Anonymous , You can create a local date table in direct Query, That will convert it into mixed mode
Date = Calendar(Min(Table1[Date]), Max(Table1[Date]))
refer if needed
https://www.youtube.com/watch?v=24arfrD3Qzk&list=PLPaNVDMhUXGbKatyDdOhGbTL3xW2Xy6pA&index=6
https://www.youtube.com/watch?v=cQfJ0GmQ5os&list=PLPaNVDMhUXGbKatyDdOhGbTL3xW2Xy6pA&index=7