Forum Discussion
omkar_nag123
4 years agoRegular Visitor
Attrition Rate
Hi, Community I have HR sample data, I'm trying to calculate Attrition Rate Following are the images of my data, Can you suggest any Dax from the below data.
amitchandak
4 years agoSuper User
omkar_nag123 , for Attrition Rate, you need hire date too ?
example
a measure like
Attrition Rate =
divide([Terminated Employees], [Current Employees])
omkar_nag123
4 years agoRegular Visitor
Hi amitchandak
I've hire date column.
how to calculate Terminate and Current Employees
Ps: I'm new to power bi