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])

     

Desauv's avatar
Desauv
Frequent Visitor
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])