Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
Ask a Question

Create a date table based on a date range in Power BI

1 like 0 dislike
783 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]))
deBUG Community deBUG.to
If you don’t ask, the answer is always NO!
...