Create a Calendar Table based off values from another table

[PavB]

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

[FreemanZ]

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?