Forum Discussion

karlosdsouza's avatar
karlosdsouza
Helper II
8 years ago

Attrition

I have a problem at hand to calculate the attrition % by formula (e.g. for Attrition% of May = Attrition between 30 Apr and 31st May) *2 / (HC on 30 Apr + HC on 31st) / 2 and similarly YTD %. I have data of all new joinees historically joined the company with thier Last working day wherever applicable. I have tried various things however failed to compute the same in Power BI. Is it a problem solvable and if yes, please help. I have searched almost everywhere

Need Help
Tips and Tricks

1 Reply

  • MFelix's avatar
    MFelix
    Super User
    8 years ago

    Hi karlosdsouza,

     

    Can you share some sample data and explanation of how you make the calculations based on those numbers so we see expected results?

     

    Regards,

    MFelix