cancel
Showing results for
Did you mean:
Helper II

## Calculate Employee Retention

Hi Folks,

Our company uses non standard retention calcs.

Work on the premise of: Cumulative(Number of leavers) divided by the Average Monthly Headcount for the selected periods.

I am nearly there with the calcs, on a sample dataset, just need three more calcs as stated in the excel Orange.

Hoping someone can help.

Excel

PBIX

Thanks.

4 REPLIES 4
Community Support

## Re: Calculate Employee Retention

Create the measures as below.

`Cumulative Headcount Rolling = CALCULATE(SUM(Table1[Headcount at Period End]),FILTER(ALL(Table1),Table1[Fiscal Month No]<=MAX(Table1[Fiscal Month No])))`
`Cumulative Headcount Rolling ave = [Cumulative Headcount Rolling]/MAX(Table1[Fiscal Month No])`
`Cumulative new leavers = CALCULATE(SUM(Table1[New Leavers in Month]),FILTER(ALL(Table1),Table1[Fiscal Month No]<=MAX(Table1[Fiscal Month No])))`

For more details, please check the pbix as attached.

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Helper II

## Re: Calculate Employee Retention

Could you look at my PBIX file attached earlier?

I am using measures, so cannot do as you have stated.

Any help appreciated.

Thanks,

Community Support

## Re: Calculate Employee Retention

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Community Support

## Re: Calculate Employee Retention

Could you please share the file to me again?

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Announcements

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

#### Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

#### Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors