Create a Calendar Table based off values from another table

PavB — Tue, 07 Feb 2023 17:26:35 GMT

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

Re: Create a Calendar Table based off values from another table

FreemanZ — Tue, 07 Feb 2023 21:10:12 GMT

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?

topic Re: Create a Calendar Table based off values from another table in DAX Commands and Tips

Create a Calendar Table based off values from another table

Re: Create a Calendar Table based off values from another table