Forum Discussion
Issue Cumulative Sales based on Week
Hi guys, i am worried about the issue that i had couple days ago and today is my deadline to deliver a report. Well lets start by explaining the used measures: Total Revenues = SUM('Sale...
Cumulative Revenues LY =
Var MaxDate = MAX('Dim Calender Sales Invoice'[Date])
Var LastYear = YEAR(TODAY())-1
Return
Calculate([Total Revenues];
ALL('Dim Calender Sales Invoice');
'Dim Calender Sales Invoice'[Year] = LastYear;
'Dim Calender Sales Invoice'[Date] <= MaxDate
)
Replace [Total Revenues LY] with [Total Revenues] in the measure above.
I'm acutally not sure what is causing this behaviour, it's really strange. For some reason the
'Dim Calender Sales Invoice'[Year] = LastYear;
Filter isn't doing what it should. You should not have 2019 and 2020 appear in the matrix.
Hello tex628,
unfortunalty the issue isnt solved yet. I also ried to rebuilt my Dim Calender table but still the issue is there.