Hello there !!.. incase anyone is available to answer my query (i know christmas holidays is not the best time for this slight_smile: )
i am struggling with calculating cummulative last year sales with a non standard calendar.
Sales LY = VAR CurrentYear = SELECTEDVALUE('calendar'[Sales Year]) VAR CurrentWeekNo = SELECTEDVALUE('calendar'[Sales Week]) VAR CurrentDayOfWeek = SELECTEDVALUE('calendar'[Day of Week]) RETURN CALCULATE([Total Sales], FILTER(ALL('calendar'), 'calendar'[Day of Week] = CurrentDayOfWeek && 'calendar'[Sales Week] = CurrentWeekNo && 'calendar'[Sales Year] = CurrentYear - 1 ))
**** below is not working :
Cummulative LY = CALCULATE([Sales LY], FILTER(ALL('calendar'),'calendar'[Day] <= MAX('calendar'[Day]))
Any help will be great.