topic TOTALWTD not recognizing Calendar in DAX Commands and Tips

TOTALWTD not recognizing Calendar

linkide — Thu, 16 Oct 2025 08:14:59 GMT

Trying to use the new TOTALWTD DAX function with AdventureWorks sample dataset:

TOTALWTD(

SUM(Sales[Sales Amount]),

CalendarTable[Date])
)

but it's giving me an error:

TOTALWTD's parameter 2 must be a calendar reference.

My Calendar table is completely fine: no gaps, marked as a Calendar table.

If I change TOTALWTD to TOTALYTD, so that would be

TOTALYTD(

SUM(Sales[Sales Amount]),

CalendarTable[Date])
)

I'm getting no errors; suddenly the Calendar table is fine. Is anyone else able to use this function? What am I missing?

Re: TOTALWTD not recognizing Calendar

Kedar_Pande — Thu, 16 Oct 2025 10:52:53 GMT

TOTALWTD(
SUM(Sales[Sales Amount]),
'CalendarTable'[Date],
, // Optional filter
"MON" // Week starts Monday
)

If this answer helped, please click Kudos or mark as Solution.
-Kedar
LinkedIn: https://www.linkedin.com/in/kedar-pande

Re: TOTALWTD not recognizing Calendar

djurecic — Thu, 16 Oct 2025 16:24:43 GMT

Hi linkide ,

You have to set up a calendar first to use this function- please see my reply here:

https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/TOTALWTD-not-recognizing-Calendar/m-p/4851511

Re: TOTALWTD not recognizing Calendar

Anonymous — Fri, 17 Oct 2025 08:56:45 GMT

Hi linkide ,

I would also take a moment to thank Kedar_Pande , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions

Re: TOTALWTD not recognizing Calendar

Anonymous — Tue, 21 Oct 2025 12:09:50 GMT

Hi linkide ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you