Hello, I want to show cumulative total for selected week only. My “selected week” measure is working fine. It shows the selected week number if any week is selected, else the current week as default.
Please let me know where am i going wrong with this.
Cumulative Sales = CALCULATE([Total Sales],
FILTER(CALCULATETABLE(‘Calendar’,‘Calendar’[Sales Week Number] = [Selected Week]),
‘Calendar’[Day of Week] <= MAX(‘Calendar’[Day of Week])))
Calendar table looks like and connect with Sales table using Day column
Day | Day of Week | Week Number | Year
31/12/2017 | 07 | 52 |2017
Thanks for the help.