Cumulative Total prior year Matrix Total

sam.mckay · May 23, 2019, 5:39am

You don’t really have to use the cumulative total here because it’s in the card and you just want to total.

So SALES LY should be fine to use.

But you’ll want to modify it.

Something like this is likely all you need.

Sales LY To Current Date = 
VAR LastTransactionDate = CALCULATE( MAX( Sales[OrderDate] ), ALL( Dates ) )

RETURN
IF( HASONEVALUE( Dates[Date] ),
    IF( SELECTEDVALUE( Dates[Date] ) <= LastTransactionDate, [Sales LY], BLANK() ),
        SUMX( 
            FILTER( ALLSELECTED( Dates[Date] ), Dates[Date] < LastTransactionDate ),
                [Sales LY] ) )