Forum Discussion
Siddiq8686
Helper I
4 years agoStaff Turnover - Need Help
Hello Everyone, I need help in turnover measure. I have already made that and its working fine over month and years. but when i needs to calculate the overall turnover for all years it gives wron...
- 4 years ago
Hi Siddiq8686
Here is the file with the solution https://www.dropbox.com/t/VXuA2561R4sF1Pul
The data model looks like this
The flag calculated column in the Merge_File3 table isQuarterly Population = IF ( MONTH ( Merge_File3[Payroll Process Date] ) IN { 1, 4, 7, 10 }, TRUE )The measures are
Average Population = VAR MonthlyPopulation = SUM ( Merge_File3[FTE] ) VAR QuarterAveragePopulation = AVERAGEX ( VALUES ('Calendar Table'[Year Quarter] ), CALCULATE ( SUM ( Merge_File3[FTE] ), Merge_File3[Quarterly Population] = TRUE ) ) VAR Result = IF ( HASONEVALUE ( 'Calendar Table'[Year Month] ), MonthlyPopulation , QuarterAveragePopulation ) RETURN ResultEmployee Left = COUNTROWS ( Separation_Data4 )Employee Left RT = VAR LastMonthInFilter = MAX ('Calendar Table'[Year Month Number] ) RETURN CALCULATE ( [Employee Left], REMOVEFILTERS ('Calendar Table' ), 'Calendar Table'[Year Month Number] <= LastMonthInFilter )% Turnover = DIVIDE ( [Employee Left], SUMX ( VALUES ('Calendar Table'[Year] ), [Average Population] ) )New Hires = COUNTROWS ( Hireing_Data )Hires RT = VAR LastMonthInFilter = MAX ( 'Calendar Table'[Year Month Number] ) VAR Result = CALCULATE ( [New Hires], REMOVEFILTERS ( 'Calendar Table' ), 'Calendar Table'[Year Month Number] <= LastMonthInFilter ) RETURN ResultTotal Population = [Hires RT] - [Employee Left RT]Your report looks like this
Please let me know if you still have any doupt.
Siddiq8686
Helper I
4 years agotamerj1 ,
Thanks for your time and response,
Let me check the calculations i will inform you if any help is required.
Thanks,
Sid
- Anonymous4 years agoNot applicable
Hi Siddiq8686 ,
Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.
Any comment or problem, please feel free to let us know.
Best Regards