Forum Discussion

tobiasmcbride's avatar
tobiasmcbride
Icon for Helper III rankHelper III
6 years ago

Data rolling measure question

Hi,   I have some Headcount data that includes the position, team, when they started and, if applicable, when they left, together with what positions are established and those who have left. It is ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Check if this blog on similar topic can help

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

tobiasmcbride's avatar
tobiasmcbride
Icon for Helper III rankHelper III
6 years ago

Thanks for that tip. However I can't see where I can do this rolling attrition from today.

 

In other words, I want the calculation to work out the number of people who have 'left' in the column 'current status' but to do so over a dynamic time period such that it takes today and minuses 12 months. It would then take that figure and divide it by the total number of employees who have 'established' in their 'current status' column as of the present time. 

 

Could you or anyone else assist specifically with that and do point out of I've missed something but coul;dn't see directly how to calculate that in your post.