Turnover rate after 90 days

[Anonymous]

Hello 

I am trying to calculate my turnover rate after 90 days, considering the new hires who left the company after 90 days of their start date,

Is there some DAX that can help me?

Thanks 

[v-lid-msft]

Hi @Anonymous ,

We can try to create a measure to meet your requirement:

Rate =
DIVIDE (
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[Name] ),
        FILTER (
            'Table',
            'Table'[HireDate] <> BLANK ()
                && 'Table'[LeaveDate] - 'Table'[HireDate] >= 90
        )
    ),
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[Name] ),
        FILTER ( 'Table', NOT ( 'Table'[LeaveDate] - 'Table'[HireDate] <= 90 ) )
    ),
    0
)

If it doesn't meet your requirement, Could you please show the exact expected result based on the tables that we have shared?

By the way, PBIX file as attached.

Best regards,

[Anonymous · Accepted solution]

@v-lid-msft  Thank you. It will be very helpful to me

[amitchandak]

@Anonymous 

Have diff between Hire Date and termination date

A new column

Diff = Datediff([Hire date], [Termination date],Day)

You can use that