Generate Date table in Direct Query Mode

[Anonymous]

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 

[amitchandak · Accepted solution]

@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