Need help on Dynamic Calendar measures.

clarawang_12 — Tue, 28 Mar 2023 13:39:02 GMT

Dear all,

I have created a measure that shows dynamic calendar, which ranges from first date to last date of certain report.

However errors popped out, can you pls shed a light on this measure? Thanks.

----------------------------------------------

DynamicDate = ADDCOLUMNS(

CALENDAR(FIRSTDATE('TicketList'[Created]),LASTDATE('TicketList'[Created])),

"Year",YEAR([Date]),

"Quarter",ROUNDUP(MONTH([Date])/3,0),

"Month", MONTH([Date]),

"Week",WEEKNUM([Date]),

"Month Year",YEAR([Date]) * 100 + MONTH([Date]),

"WeekDay",WEEKDAY([Date])

)

Re: Need help on Dynamic Calendar measures.

johnt75 — Tue, 28 Mar 2023 15:30:23 GMT

Do you have auto date/time enabled? If so I think you would need to use

DynamicDate = ADDCOLUMNS ( CALENDAR ( MIN ( 'TicketList'[Created].[Date] ), MAX ( 'TicketList'[Created].[Date] ) ), "Year", YEAR ( [Date] ), "Quarter", ROUNDUP ( MONTH ( [Date] ) / 3, 0 ), "Month", MONTH ( [Date] ), "Week", WEEKNUM ( [Date] ), "Month Year", YEAR ( [Date] ) * 100 + MONTH ( [Date] ), "WeekDay", WEEKDAY ( [Date] ) )

topic Need help on Dynamic Calendar measures. in DAX Commands and Tips

Need help on Dynamic Calendar measures.

Re: Need help on Dynamic Calendar measures.