Cumulative comparison today to same period last year

Anonymous — Wed, 01 Apr 2020 13:08:28 GMT

Hi all,

I am trying to make a comparison of the cumulative sales of this year until today compared to the cumulative sales of last year until the same week and weekday. I've got a measure that calculates it for this year until today and this works like a charm. Now I would like to create the same measure but for the previous year to show the cumulative total until the same week and same weekday as today, but I cannot make it work.

The working measure is as follows:

Cumulatief Total LCY = VAR GroterDanVandaag = CALCULATE( LASTDATE(Shipment[Loading date]); ALL(Shipment)) RETURN IF( SELECTEDVALUE( CalendarTable[DateKey] ) > GroterDanVandaag; BLANK(); CALCULATE ( [Som Total LCY] ; FILTER ( ALLSELECTED( CalendarTable[DateKey] ); CalendarTable[DateKey] <= MAX ( CalendarTable[DateKey] ) ); FILTER ( ALLSELECTED ( CalendarTable[ISOYear] ); CalendarTable[ISOYear] = MAX ( CalendarTable[ISOYear] ) ) ) )

How can I create the same for last year?

Re: Cumulative comparison today to same period last year

Pragati11 — Wed, 01 Apr 2020 16:01:09 GMT

Hi Anonymous ,

Try using SAMEPRIODLASTYEAR Dax:

https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

topic Cumulative comparison today to same period last year in DAX Commands and Tips

Cumulative comparison today to same period last year

Re: Cumulative comparison today to same period last year