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

richbenmintz's avatar
richbenmintz
Icon for Resident Rockstar rankResident Rockstar
6 years ago

Hi sarah2_williams ,

1020 is the the cummulative total for the academic year 19/20, you are missing the current year cummulative total in the example you provide, when i checked the prior year cummulative total it matches the current year cummulative total on the the corresponding dates in the prior year.

 

the updated file can be found here, https://1drv.ms/u/s!AhCeuF2piSWMg6EPCOW1TqN2V036UQ?e=Ch2lW5 

 

Hope this Helps,
Richard
Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

  • sarah2_williams's avatar
    sarah2_williams
    Icon for Helper III rankHelper III
    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

  • richbenmintz's avatar
    richbenmintz
    Icon for Resident Rockstar rankResident Rockstar
    6 years ago

    Hi sarah2_williams ,

     

    The Card has no filters applied, meaning that the context for that visual has no Year or Date, if you click on one of the the Academic year rows in your matrix it will update the correct number.

     

    Make sense?