Forum Discussion

PavB's avatar
PavB
Frequent Visitor
3 years ago

Create a Calendar Table based off values from another table

Hello,

I am creating a sales report and want to create a calendar that starts with 1/1 and min year in the sales table and ends with 12/31 and max year in the sales table. 

CalendarTbl = Calendar(Date(Year(Min('F-Sales'[Xtn Date])), 1, 1), Date(Year(Max('F-Sales'[Xtn Date])), 12, 31))
I also need columns for Year, Qtr, Month - with Hierarchies created automatically.
Appreciate your suggestions for a good way to do it.
Is it better to do it via Power Query or DAX?
Thanks,
Pav
 
Calendar Table

1 Reply

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    hi PavB 

    your code shall already get what you need. you can simplify that further like:

    CalendarTbl = CALENDARAUTO()  //that's all.

    Or did i misunderstand you?