Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am working on my first Power BI for HR analytics Metrics. I am successful with all the visualizations and other basic calculations. Little confused with calculating the turnover for financial year.
1. I have 2 types of year in DateTable(normal year and financial year - from october to september) - all the other changes and calculations are based on normal year ut just for the Turnover I need to use the Financial year. I dont know how to do that.
Turnover = Employees left during the financial year / permanent employees at start of financial year
Employees left during the financial year = CALCULATE(DISTINCTCOUNT(HRMetricsData[EmpId]), USERELATIONSHIP(HRMetricsData[Termination Date],DateTable[Date]),NOT(ISBLANK(HRMetricsData[Termination Date]))) - this calculates for normal year, how should I do for financial year?
I think both of those measures should work if you include them with the Fiscal Year column in a table / matrix or other visual.
You might want to add an additional clause in the permanent employees measure to count employees where either the termination date is blank or is after the max date.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.