topic Re: HR METRICS - Sum FTE Headcount to get monthly running Total in DAX Commands and Tips

HR METRICS - Sum FTE Headcount to get monthly running Total

HRAnalyst — Thu, 27 Jul 2023 10:56:06 GMT

Hi,

I have used the below measure to calculate my monthly rolling headcount (heads in the organisation) - however I was wondering if there is a way I can alter the DAX Formula to create a sum of our FTE Headcount?

Employee First Name	Employee Start Date	Employee Last Day of Employment	Employee FTE
A	01/01/2022		0.57
B	02/02/2022	04/02/2022	1.00

Current Employees =

CALCULATE(
COUNTX(
FILTER( 'Employee Information','Employee Information'[Start Date]<=MAX(Dates[Date] )

&& ( ISBLANK( 'Employee Information'[Last Day of Employment] )

|| 'Employee Information'[Last Day of Employment]>MAX(Dates[Date] ) ) ),

( 'Employee Information'[First Name] ) ),
CROSSFILTER( 'Employee Information'[Start Date], Dates[Date], None )
)

Re: HR METRICS - Sum FTE Headcount to get monthly running Total

HRAnalyst — Thu, 27 Jul 2023 10:57:10 GMT

For context - my date tables currently do not have an active relationship to the data set

Re: HR METRICS - Sum FTE Headcount to get monthly running Total

Anonymous — Mon, 31 Jul 2023 06:05:28 GMT

HI HRAnalyst,

For date range analysis requirement based on multiple date fields, you can take a look at the following link start date end date part if helps:

Before You Post, Read This: start, end date

Regards,

Xiaoxin Sheng