Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a problem for turnover calculation.
Calculation of turnovers i would like to calculate;
period leavers / (number of employees at the begining + number of employees at the end ) / 2).
For the January; January total number of leavers / ((number of employees at the beginning of January+ number of employees at the end of January)/2)
Example: 10 person left January /((100 beginning of January+105 end of January)/2)= 9,76%
How can I calculate it?
Many thanks.
Solved! Go to Solution.
Thanks. I solved the problem.
Solution:
Thanks. I solved the problem.
Solution:
Hi, @ugurozdemir ;
10 person left January /((100 beginning of January+105 end of January)/2)= 9,76%
I think this formula works, you create a measure in PowerBI and divide (count), (start + end) /2
It would be even better if you had a simple sample.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Please show the expected outcome.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523