TOTALWTD not recognizing Calendar

[linkide]

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?

[v-sshirivolu]

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

[v-sshirivolu]

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

[djurecicK2 · Accepted solution]

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-...

[Kedar_Pande]

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