Forum Discussion
Solved
TOTALWTD not recognizing Calendar
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:
)
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
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?
