Inactive Employees

[RV1]

Hi. I am working on HR Dashboard and I have published the Total Headcount (DISTINCT Employees who are not terminated in the Employee Table) and Active Headcount (Distinct Employees who were paid in last pay run in the Transactions Table).

I want to provide a list of Inactive Employees i.e. staff who are still in our payroll but were not eligible for pays (e.g. staff on LWP or parental leave).

Can somebody help me with this query? I am relatively new to Power Bi.

Thanks in advance.

[v-yulgu-msft · Accepted solution]

Hi @RV1,

To list all inactive employees, you could new a table with this formula:

Table =
EXCEPT ( VALUES ( 'Employee Table'[Employees] ), VALUES ( Transaction Table[Employee names] ) )

Regards,

Yuliana Gu

[RV1]

Thanks. This gave me the direction. My query is more complicated as I have to filter out terminated staff from the Employee table first and compare them to the payrun transactions for the select pay period only. But overall it worked. Many thanks.

[Floriankx]

Hello,

shouldn't this be the difference between Total Headcount and Active Headcount?

If not please tell us how the Inactive Employees can be identified.

Best regards.

[RV1]

Sorry if my query was not very clear.

There may be staff who are currently on unpaid leave (parental leave, study leave, whatever). They do not have a termination date against them. Hence they are counted under the Headcount. But since they have not received a pay, they are Inactive. I want to generate a list of inactive staff for verification that we have not missed anybody during pay runs.