Forum Discussion
TOTALWTD not recognizing Calendar
Trying to use the new TOTALWTD DAX function with AdventureWorks sample dataset:
)
but it's giving me an error:
My Calendar table is completely fine: no gaps, marked as a Calendar table.
If I change TOTALWTD to TOTALYTD, so that would be
)
I'm getting no errors; suddenly the Calendar table is fine. Is anyone else able to use this function? What am I missing?
4 Replies
- Kedar_Pande
Super User
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 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
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
