Forum Discussion

asa70's avatar
asa70
Advocate I
1 year ago
Solved

Dynamic 12 Month YTD Calculation

Hi all,    I hope you are well,   I'm currently doing a 12 month YTD calculation and what should be a simple calculation, is proving to be quite the challenge. I think I'm missing something in be...
Need Help
  • v-sshirivolu's avatar
    v-sshirivolu
    11 months ago

    Hi asa70 ,
    After thoroughly reviewing the details you provided, I was able to reproduce the scenario, and it worked on my end. I have modified few things in pbix  and successfully implemented it.     

    I am also including .pbix file for your better understanding, please have a look into it:

    Thank you for using Microsoft Community Forum.

v-sshirivolu's avatar
v-sshirivolu
Community Support
11 months ago

Hi asa70 ,
After thoroughly reviewing the details you provided, I was able to reproduce the scenario, and it worked on my end. I have modified few things in pbix  and successfully implemented it.     

I am also including .pbix file for your better understanding, please have a look into it:

Thank you for using Microsoft Community Forum.

asa70's avatar
asa70
Advocate I
11 months ago

Hi v-sshirivolu , thank you so much for the solution. I have viewed and tested it on my end. It works as expected!

Kind Regards,

Asa