Forum Discussion
Week to date Calculation group
Trying to figure out the syntax for a week-to-date measure based on Sunday being the first day of the week.
Does anyone have anything that could point me in the right direction?
Here is what I have done for MTD:
CALCULATE ( SELECTEDMEASURE (), CALCULATETABLE ( DATESMTD ( 'Calendar'[Date] ), 'Calendar'[IsPast] = TRUE () ) )
1 Reply
I think you can find the answer in the following link:
For Sunday being the first day make sure in the weekday formula to put the number 1 (as return type).
e.g. WEEKDAY('Date'[Date],1)
