Forum Discussion

BrendaB's avatar
BrendaB
Frequent Visitor
2 years ago
Solved

Calculating Last Year Issue

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 sam...
Last Year
SAME PERIOD LAST YEAR
  • BrendaB's avatar
    BrendaB
    2 years ago

    For whatever reason, this is the measure that worked. 

    Thanks for the help.

     

Anand24's avatar
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