Forum Discussion
Siddiq8686
Helper I
4 years agoEmployee Turnover
Hello Everyone, I am attaching a table below showing month wise employee population and separations (employees who left the organization. MonthQTRPopulationLeaversTurnover Jan QTR 1 283...
- 4 years ago
Siddiq8686
The final report looks like this
Make sure you adjust relations like this
Following are the measures' code:Employee Left = SUM ( Separation_Data4[FTE] )Population = VAR MonthlyPopulation = SUM ( Payroll_Merge_File[FTE] ) VAR QuarterAveragePopulation = CALCULATE ( AVERAGE ( Payroll_Merge_File[Quarterly Population] ), ALLSELECTED (Calendar_Table ), CROSSFILTER ( Calendar_Table[Date], Payroll_Merge_File[Payroll Proces Date], None ), USERELATIONSHIP (Calendar_Table[Year Quarter], Payroll_Merge_File[Year Quarter] ) ) VAR Result = IF ( HASONEVALUE ( Calendar_Table[Year Month] ), MonthlyPopulation , QuarterAveragePopulation ) RETURN ResultMonthly Turnover = DIVIDE ( [Employee Left], [Population] ) - 4 years ago
This solution is working fine
Siddiq8686
Helper I
4 years agoThis solution is working fine