Forum Discussion

Danny-Happy's avatar
Danny-Happy
Icon for Helper I rankHelper I
6 years ago
Solved

Calculate average FTE 2020

Hi All,   I like to calculate the average FTE per month for 2020. I already calculate the FTE per month with this DAX:   Count FTE = CALCULATE(    SUM( 'Dim - employees'[FTE] ) ,    FILTER( ...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Danny-Happy , Try like this and divide my month

    Count FTE =
    sumx(Values('Dim - time'[Month Year])
    CALCULATE(
    SUM( 'Dim - employees'[FTE] ) ,
    FILTER('Dim - employees '[date hired] , 'Dim - employees '[date hired] <= MAX( 'Dim - time'[Day] )) ,
    FILTER('Dim - employees'[date leave] , OR( 'Dim - employees'[date leave]>= MIN( 'Dim - time'[Day] ) , ISBLANK( 'Dim - employees'[date leave] ))
    )
    ))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Danny-Happy , Try like this and divide my month

Count FTE =
sumx(Values('Dim - time'[Month Year])
CALCULATE(
SUM( 'Dim - employees'[FTE] ) ,
FILTER('Dim - employees '[date hired] , 'Dim - employees '[date hired] <= MAX( 'Dim - time'[Day] )) ,
FILTER('Dim - employees'[date leave] , OR( 'Dim - employees'[date leave]>= MIN( 'Dim - time'[Day] ) , ISBLANK( 'Dim - employees'[date leave] ))
)
))

Danny-Happy's avatar
Danny-Happy
Icon for Helper I rankHelper I
6 years ago

Works perfect.

Thank you so much!