Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
1 like 0 dislike
555 views
in Power BI by 4 4 11
I want to create a date table based on the current dates available in your tables for example .. created date startd from 01-01-2020 till 30-06-2020

1 Answer

1 like 0 dislike
by 4 4 11
 
Best answer

If you want to create a date table based on the current dates available in your tables, you can use the MIN and MAX functions to determine the minimum and maximum dates in your dataset and then generate a date table based on that range.

DateTable = CALENDAR(MIN('YourTableName'[DateColumn]), MAX('YourTableName'[DateColumn]))
If you don’t ask, the answer is always NO!
...