Forum Discussion

Desauv's avatar
Desauv
Frequent Visitor
4 years ago
Solved

Calculating FTE Turnover (Resigned date problems)

Hi   I'm trying to calculated FTE turnover, which giving me some headaches. I know the formula for the Turnover Rate, but I'm having a hard time calculating the correct number resigned FTE in the s...
  • Desauv's avatar
    Desauv
    4 years ago

    Hi Alisa

     

    Actually I just found a solution for my problem.

     

    FTE_Resigned_4 = 

SUMX(
    FILTER(    
        FILTER('HR data ', 'HR data'[ResignedDate] <> BLANK()),
        AND('HR data'[ResignedDate] <= EOMONTH('HR data'[Date].[Date],0),'HR data'[ResignedDate] >= EOMONTH('HR data'[Dato].[Date],-1)+1)
        )
, 'HR data'[FTE])

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Desauv 

Can you provide your data for me ? There is nothing wrong with the formula alone . If possible, you can provide your pbix file(remove sensitive info) to us so that we can deal with your problem easier .

 

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.