Employee turnover calc

[OilMan_8490]

I am trying to find Employee turnover by Year/Company

I have and employee table and I have created a Calendar table

The employee table has the following columns
ID
Hire Date
Term Date
Company
Active Status

I would like to createa dashboard to show by
Company turnover % by Year (2018 & 2019)-- Matrix Chart
Turnover by Month --- Line Chart (as a whole)

please help...

 

[Matt Allington]

This is a non trivial task. I suggest you read up on “events in progress” https://blog.gbrueckl.at/2014/12/events-in-progress-for-time-periods-in-dax/. You need to be clear how the % turnover is calculated first, then work out the DAX.