Cummulative last year sales


#1

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.

Regards
Grace


#2

sorted this one :). …please ignore


#3

That’s great. Do you mind adding the correct solution?

Thanks