Forum Discussion

unnijoy's avatar
unnijoy
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

YTD Attrition

I am trying to find the YTD Attrion. Below is the Sample data. I tried using Total YTD and DatesYTD function But these are not gving me the correct values. Please help.   Month Attrition Jan...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi unnijoy ,

 

In your sample, 

Mar-20 385

March 2020 is 385, so you will get 234 + 678 + 385 = 1297, right?

 

Aiolos Zhao

unnijoy's avatar
unnijoy
Icon for Post Prodigy rankPost Prodigy
6 years ago

Anonymous ,

 

This issue was with the uploaded data. I refresh the data and i got the values correct. Thanks for your help.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    glad to help you unnijoy 

     

    Could you please set my answer as the solution so other people will know the thread is solved.

     

    Thanks.

    AiolosZhao