Forum Discussion
linkide
10 months agoFrequent Visitor
TOTALWTD not recognizing Calendar
I'm trying to test out the new TOTALWTD DAX function with TOTALWTD( SUM(Sales[Sales Amount]), CalendarTable[Date]) ) But it's giving me an error: TOTALWTD's parameter 2 must be a...
- 10 months ago
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:
linkide
10 months agoFrequent Visitor
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.