Cumulative comparison today to same period last year

[Anonymous]

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?

[Pragati11]

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