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

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

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.

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