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: TOTAL...
Kedar_Pande
Super User
Super UserTOTALWTD(
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