Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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. 

 

2 Replies

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion

    Hi Anonymous

     

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.