Forum Discussion
TOTALWTD not recognizing Calendar
Hi linkide ,
Yes, this is one of the new Enhanced DAX Time Intelligence functions. You need to set up a calendar first- here are some articles on how to do it:
Super UserTOTALWTD(
SUM(Sales[Sales Amount]),
CalendarTable[Date],
,
"MON"
)
If this answer helped, please click Kudos or mark as Solution.
-Kedar
LinkedIn: https://www.linkedin.com/in/kedar-pande
Unfortunately, that doesn't help. I did some more digging and I think this function actually needs the preview tailored Calendar: https://powerbi.microsoft.com/en-us/blog/calendar-based-time-intelligence-time-intelligence-tailored-preview/
That way, the error is gone. Now I just cannot get it to produce correct results. How should the week be defined? I've tried week number and a complete week number "2025 Week 42", but no luck.