topic Getting Beginning Employee for Attrition Percentage in DAX Commands and Tips

Getting Beginning Employee for Attrition Percentage

Easley06 — Mon, 06 Feb 2023 05:08:39 GMT

Hi,

is this possible for my current dataset to get the beginning employer per month.

current dataset i have the Hiredate and separation date this is for attrition report.

End employee = (beg employee + new hires) - separations

but the problem is how to get the previous end employee to be the beg employee for the next month?

Thankyou.

FreemanZ — Mon, 06 Feb 2023 06:01:51 GMT

How do you plan to present the needed meaure or calculated column?

Easley06 — Mon, 06 Feb 2023 06:31:43 GMT

hi sir,

for table purposes and need the attrition percentage for visuals.