Calculate the attrition for new hired (<= 6 months of hired date)

zinah

Active Member
Joined
Nov 28, 2018
Messages
353
Office Version
  1. 365
Platform
  1. Windows
Hi,

I need to calculate the voluntary attrition for employees who left the company within less than or equal to 6 months of their hire date. How would I accomplish this?

I have below fields and tables:

- Attrition Table that has below fields:

- Employee ID

- Hire Date

- Term Date

- Term Category (voluntary , involuntary, Neutral)

And I have an active slicer that has the report date.


Thank you!
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
* (term date - hire date) <= 6 months
* term date is known
* term category = voluntary
 
Upvote 0
* (term date - hire date) <= 6 months
* term date is known
* term category = voluntary
Can you help with writing the syntax as DAX language? I tried below measure but I got the error message below. Can you help?

EO_Current_Month = EOMONTH(TODAY(),-1)
EO_Last_6 Months = EOMONTH(TODAY(),-7)+1

1646782235466.png
 
Upvote 0

Forum statistics

Threads
1,213,484
Messages
6,113,920
Members
448,533
Latest member
thietbibeboiwasaco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top