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 share.
MyTable(2021-01-01-2021-09-27) - something like this.
Please help
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
1 Reply
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