Monthly Retention Rate

[benz-fsproduce]

I am looking to calculate retention rate. I have a seperate table with dates and I have hire date, term date, and many more columns to use. I have been trying to figure this out for a while now and would love some help. I would also love to have "current staff","current terms", "new hires" all by month. I have added a link to my published PowerBi. Any help would be awesome, thanks.

https://app.powerbi.com/links/rCxHyJvyq0?ctid=a544b575-cd97-4b77-9957-2d709aa16a55&pbi_source=linkSh...

[amitchandak · Accepted solution]

@benz-fsproduce , No access to file.

refer if these can help

https://community.powerbi.com/t5/Desktop/Retention-Rate-HR/m-p/474135

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Retention-Rate/m-p/2329168

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.