Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Average calculation

Hi, I hope you can help me. I want to calculate average FTE per month. I have made the following example, but I cannot figure out how to calculate the FTE Avg. In February it should be based on the...
mahoneypat's avatar
mahoneypat
Microsoft Employee
6 years ago

Please try this expression.

 

Avg FTE To Date =
VAR thismonth =
    MIN ( 'Calendar'[Month] )
RETURN
    CALCULATE (
        AVERAGEX (
            VALUES ( 'Calendar'[Month] ),
            CALCULATE ( SUM ( 'ActualData'[Actual] ) )
        ),
        ALL ( 'Calendar'[Month] ),
        'Calendar'[Month] <= thismonth
    )

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat