Calculating Last Year Issue

[BrendaB]

Hi again. 

Having an issue with my LY cacluation. I have data in the matrix from 2020-2023 and need to see LY's results number in a column for each year.  The below calculation is carring the same number for each year. I have tried various built in calculations, but I end up with no data in my column. I am sure I am missing something simple...thanks in advance. 

[BrendaB · Accepted solution]

For whatever reason, this is the measure that worked. 

Thanks for the help.

[BrendaB]

I am wondering if there is an issue because I am using the 'Date'Date Hierarchy'' that was created within my 'consolidatedupload' table, rather than using a separate date table. I tried both of the solutions above, and they both result in a 'blank' (see below). I did drop the matrix in a table form to try and figure out what went wrong, and although there was a total at the bottom, the individual rows were all blank. 

[Anand24]

Hi @BrendaB ,
Create a calculated measure with below dax and pull into matrix:

LY $ = CALCULATE(SUM('ConsolidatedUpload'[NetChanges]), DATEADD('ConsolidatedUpload'[Date], -1, YEAR))

OR

LY $ = CALCULATE(SUM('ConsolidatedUpload'[NetChanges]), SAMEPERIODLASTYEAR('ConsolidatedUpload'[Date]))

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn