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.

For whatever reason, this is the measure that worked. Thanks for the help.

Calculating Last Year Issue | Microsoft Fabric Community

Anand24
Super User
2 years ago
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
BrendaB
Frequent Visitor
2 years ago
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.
BrendaB
Frequent Visitor
2 years ago
For whatever reason, this is the measure that worked.
Thanks for the help.