Colander Table

[NewbieJono]

where is the best place to produce a calander table.

in power query or with dax in the data in model.

does anyone have any code that used to generate these tables? i currently do it manually at the moment adding a coloumn at a time using dax.

[FreemanZ]

hi @NewbieJono 

I prefer DAX, it is more convinient and flexible. 

try like:

Date =
ADDCOLUMNS (
CALENDAR (DATE(2020,1,1), DATE(2022,12,31)),
"Year", YEAR ( [Date] ),
"Qtr", "Q" & FORMAT ( [Date], "Q" ),
"MonthNO", FORMAT ( [Date], "MM" ),
"Month", FORMAT ( [Date], "MMM" ),
"Day",FORMAT ( [Date], "DD" ),
"YYQ", FORMAT ( [Date], "YY" ) & "Q" & FORMAT ( [Date], "Q" ),
"YY/MM", FORMAT ( [Date], "YY/MM" ),
"Weekday", WEEKDAY ( [Date],2 )
)

it is like:

[NewbieJono]

for max date should i use today()

[FreemanZ]

hi @NewbieJono 

it depends. TODAY() or MAX(FactTable[Date])