Urgent: Turn-Over Calculation (end of the date and begining of the date)

[ugurozdemir]

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.

[ugurozdemir · Accepted solution]

Thanks. I solved the problem.

Solution:

number of employees at the end = CALCULATE (COUNTROWS ( 'Turn Over Report' ),FILTER ('Turn Over Report','Turn Over Report'[Start Date] <= MAX ( 'Date'[Date] ) && OR ('Turn Over Report'[End Date] >= MAX ('Date'[Date] ),  ISBLANK ( 'Turn Over Report'[End Date] ) ) ))

number of employees at the begining = CALCULATE ( COUNTROWS ( 'Turn Over Report' ), FILTER ( 'Turn Over Report', 'Turn Over Report'[Start Date] <= MIN ( Date[Date] )  && OR (  'Turn Over Report'[End Date] >= MIN (Date[Date] ), ISBLANK ( 'Turn Over Report'[End Date] ) ) ))

Period Leavers = CALCULATE ( COUNTROWS ( 'Turn Over Report' ), FILTER ( 'Turn Over Report', 'Turn Over Report'[End Date] >= MIN ( Date[Date] ) && 'Turn Over Report'[End Date] <= MAX ( Date[Date] ) ) ) 

Turn-Over Rate = [Period Leavers] / ( ( [number of employees at the begining ] + [number of employees at the end] ) / 2)

[v-yalanwu-msft]

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.

[lbendlin]

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