Forum Discussion
Dynamic 12 Month YTD Calculation
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.
Hi v-sshirivolu , as per request, please see below table for a small sample with the expected outcome next to it.
Hope that helps!
Kind Regards,
Asa
| Month Year | Attrition | 12 Month To Date Attrition |
| Jan-24 | 9 | 115 |
| Feb-24 | 2 | 117 |
| Mar-24 | 2 | 119 |
| Apr-24 | 11 | 130 |
| May-24 | 10 | 140 |
| Jun-24 | 3 | 143 |
| Jul-24 | 8 | 151 |
| Aug-24 | 6 | 6 |
| Sept-24 | 2 | 8 |
| Oct-24 | 9 | 17 |
| Nov-24 | 4 | 21 |
| Dec-24 | 2 | 23 |
| Jan-25 | 7 | 30 |
| Feb-25 | 3 | 33 |
| Mar-25 | 0 | 33 |
| Apr-25 | 2 | 35 |
| May-25 | 8 | 43 |
| Jun-25 | 0 | 43 |
| Jul-25 | 5 | 48 |
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.
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