Employee Turnover

Hey Lydia,

Below is the expected result from the attached 2 table. The approach and formula will same as you calculated in first example i.e 8%.

But now 2 separated tables are uploaded to data models and are lonked with the dimension table and we need to calculate the same turnover using the previous approach and formula. The expected results are ;

Month    -             Turnover%

we need to calculate the monthly turnover as well as yearly from the data table using sums and averages but with the same previous approach.

Regards,

Muhammad Siddiq