Forum Discussion
YTD Attrition
Hi unnijoy ,
Do you want to calculate an accumulated result?
If yes, Plesae try the below measure:
measure = calculate(sum(value),filter(all(date),date <= max(date)))
Aiolos Zhao
Hi unnijoy ,
Do you want to calculate an accumulated result?
If yes, Plesae try the below measure:
measure = calculate(sum(value),filter(all(date),date <= max(date)))
Aiolos Zhao
hi Anonymous
when i use the formula it is giving me diffrernt value. Till up to Feb 2020 it is giving me correct value. Like Jan 2020=234
Feb 2020= 234+678=912. But for March onwards it is giving different value.
For March as per your formula insted of March 2020=234+678+633=1545 I am getting 1321. How to fix this.
Hi unnijoy ,
Based on your sample data, till up to March 2020, the value should be 234+678+385=1297. Where did 633 come from? Or there are other values in your dataset. Regardless of adding a calendar table to use totalytd() function or calculate values directly by the previous two post, both of them should work.
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi unnijoy ,
In your sample,
Mar-20 385 March 2020 is 385, so you will get 234 + 678 + 385 = 1297, right?
Aiolos Zhao
