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.

     

BrendaB's avatar
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.