POWER BI CALENDAR / DATE TABLE
If your data warehouse does not have a date table or a time table, how do you create it within Power BI….well here you go
In Power BI
Click the Modeling tab
Select New Table
Calendar = CALENDARAUTO(6)
CALENDAR – You will supply the Start and End Date
CALENDARAUTO – Looks through all the dates in the model and automatically builds out the range. If your model begins on July 15, 1979 and your fiscal year end is June 30th, if you set CALENDARAUTO(6) it will allow all dates from July 15, 1979 to June 30, 2021. If you leave CALENDARAUTO() blank, it will go to the end of the year (December 31).