Forum Discussion
TOTALWTD not recognizing Calendar
I'm trying to test out the new TOTALWTD DAX function with
)
But it's giving me an error:
There's nothing wrong with my Calendar: no gaps, marked as a Date table with the [Date] column. If I change from TOTALWTD to TOTALYTD, there's no error. In other words, this works fine:
TOTALYTD(
SUM(Sales[Sales Amount]),
CalendarTable[Date])
)
What am I missing?
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:
5 Replies
TOTALWTD(
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-pandeUnfortunately, 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.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:
Hi linkide,
Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to Kedar_Pande and djurecic for prompt and helpful responses.
Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.
Best regards,
Prasanna KumarHi linkide,
Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.
Best regards,
Prasanna Kumar
