Forum Discussion

sarah2_williams's avatar
sarah2_williams
Icon for Helper III rankHelper III
6 years ago
Solved

YoY Comparison totals - DAX Help

Hi all,   I am trying to do a year on year comparison on the number of deposits paid for courses starting in September. I have tried using the SAMEPERIODLASTYEAR function but that only gived me the...
Need Help
  • sarah2_williams's avatar
    sarah2_williams
    6 years ago

    Thanks, now I can see what you mean by showing this cumulative year. how can I rectify this in the attached image.

    In its test file, the Standalone Card has the Accumulated Measure of the previous year, which shows the correct amount 982, this is correct to note that the maximum on date is 07/08/2020, and this is the total for the academic year 2019 through 07/08/2019. I copied the DAX exaclty but my stll card shows the wrong number.

    Capture.JPG

    I can't see why it doesn't work. Maybe I'll have to try something else.

    Thank you

sarah2_williams's avatar
sarah2_williams
Icon for Helper III rankHelper III
6 years ago

Thanks

 

I now have values but for the prior year they are all out by about 20.. can you explain to me how the prior year formula identifys the date it should look for in the previous year? and why are we using "-10000". Thanks again for the help.. just trying to make sure I understand properly 🙂

S

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi sarah2_williams ,

 

Use solution from v-lili6-msft . 

 

It makes use of Time Intelligence which is needed in your case.

 

Regards,

Harsh Nathani