Calculate new employees per month
Hey there, I am trying to create a visual with the new employees for each month. Positions can occur several times but not at the same time. For example Position P-10057. ValidFrom ValidTo FullTimeEquivalent PositionId 31.12.2023 31.12.2154 0.2 P-10016 01.12.2012 31.12.2154 1 P-10017 18.01.2016 31.12.2154 1 P-10055 01.09.2017 31.12.2154 1 P-10056 01.02.2023 31.12.2023 1 P-10057 30.06.2024 14.10.2024 1 P-10057 14.11.2023 29.02.2024 1 P-10058 31.07.2024 31.12.2154 1 P-10058 01.08.2021 04.06.2024 1 P-10059 01.08.2022 30.07.2025 1 P-10060 01.08.2022 31.07.2025 1 P-10061 15.08.2022 13.08.2025 1 P-10062 01.08.2023 30.07.2026 1 P-10063 01.08.2023 08.05.2024 1 P-10064 01.08.2021 04.06.2024 1 P-10065 I use the following Dax: FTE_Onboarding = CALCULATE( SUM(PositionWorkerAssignmentsV2[FullTimeEquivalent]), FILTER( PositionWorkerAssignmentsV2, PositionWorkerAssignmentsV2[ValidFrom] >= MIN(DateTable[Date]) && PositionWorkerAssignmentsV2[ValidFrom] <= MAX(DateTable[Date]) ) ) The datetable goes from 2022 to 2026. So the missing FTE before 2022 are correct. However I am get the following result: FTE_Onboarding Year Month 3 2022 August 1 2023 Februar 2 2023 August 1 2023 November So the FTE from Dec 23 and the two FTE from 24 are missing. Looking forward to your answers 🙂
How to compute the yearly salary spendings/costs in DAX?
Hi there, As a part of a Power BI HR Dashboard, I want to showcase the yearly salary costs in a card visual as a rolling total per year. How I can transfer this to DAX code? 1. Result to achieve: Example: Test data for year 2018: Card content Cost of Salary per certain year 32.000 € Option to change specific year by slicer on Date Table Columns to work with in fact table EmpID Salary DateofHire TermDate SalaryMonthly 2. Things to consider: Employee, who was hired before a certain year and is active till end of certain year. Salary spendings needs to be calculated over all month of year (EmpID: 1). Employee, who was hired before certain year and is terminated inside certain year. Salary needs to be calculated just for active months (EmpID: 4). Employee, who was hired in certain year and is active till end of certain year (EmpID: 3). Employee, who was hired in certain year and is terminated inside certain year (EmpID: 2). 3. Data Model 3.1 Relationships Date Table & Fact table is connected via inactive relationships ‘Date’[Date] 1->* ‘Fact’[DateofHire] ‘Date’[Date] 1->* ‘Fact’[TermDate] 4. Data Set https://1drv.ms/u/s!ApbrVj8RZyxnkWev_fGDrZQdMhls?e=K3hPy5 I would appreciate, if someone can help me out. Cheers, Martin
Headcount DAX
Hello! First post and beginner - I am working on an HR Retention Dashboard and am struggling to calculate the Headcount. I have been following some tutorials from Solutions Abroad but my headcount isn't accurate as it is still counting everyone after the date I have selected to filter from. Here is the Sample Data Here is the measure: Headcount = CALCULATE( [Count of Employees], FILTER( 'Employee Data' , ( 'Employee Data'[Hire/Rehire Date] < MIN('Calendar'[Date]) && 'Employee Data'[Termination Date] > MAX('Calendar'[Date]) ) || ISBLANK('Employee Data'[Termination Date]) )) So for example, when I click January 2022 - it is still counting all of the new hires after that date. Any assistance is greatly appreciated!
Show % Employee Turnover - by month, with option to see by department, location, company
Hi, I'm pretty new to PowerBI and need help setting up an employee turnover dashboard for HR. Requirements are to be able to see employee headcount history to date and employee turnover by: location, department and company. My table data is set out as follows: Employee ID | Full Name | Company | Department | Location | Job Role | Type | Date | Staff Type = Entry / Exit to inform the Date column Staff = 1 for each employee Please could some please help advise the best way i could add an additional turnover column to this table (below) as a %. The usual calculation used in HR is: Total leavers / average employees in that time period. Many thanks!
