cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JamesS123 New Member
New Member

HR retention problem calculations

Hi All, 

 

I treid following the solution here: https://community.powerbi.com/t5/Desktop/Retention-Rate-HR/td-p/474135

 

Unfortunately it only gives me cumulative hired/fired as the same for each year (see below). 

 

I think it is to do with the first two measures, as they just seem to gather all staff but I'm a little stuck as to whats going on here. 

 

To confirm, I have a date table with all dates from 2000-2050 and a year colum with just the year from these dates. 

 

I then have a second table with employee number, and have pivoted the other colums as per the example in the link above so I have a matching format. 

 

Is there a step I am missing or similar to get it to show the additions/leavers per year? 

 

Many Thanks in advance. 

 

powerBIprob.PNG

2 REPLIES 2
Super User
Super User

Re: HR retention problem calculations

Hi @JamesS123

 

Can you at least show the code of your measures, ideally share the pbix file?

Nick_M Senior Member
Senior Member

Re: HR retention problem calculations

Can you add in what measures you are using?  If using time-intelligence functions be sure to set your calendar table to a Date table to ensure they calculate correctly.