Forum Discussion

psstack's avatar
psstack
New Member
1 year ago
Solved

DAX coding help for average FTE calculation

Hi All, I have been tryiong to develop a measure that will calculate the avgFTE over a selected period of time, but have not been able to get it to calculate correctly.  The code I have works for mo...
  • v-saisrao-msft's avatar
    v-saisrao-msft
    1 year ago

    Hi psstack,

    Thank you BeaBF,FBergamaschi, for your insights.

    I’ve reproduced your issue using sample data and confirmed the behavior. The measures are returning the expected results Ending FTE provides the final available value for the period, whereas Avg FTE Month/Quarter/Year shows the appropriate aggregation for each respective level. Ending FTE gives the last available value in the period, while the Avg FTE Month/Quarter/Year reflect the correct aggregation at each level.

    Hope this helps

    Thank you.

v-saisrao-msft's avatar
v-saisrao-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi psstack,

Thank you BeaBF,FBergamaschi, for your insights.

I’ve reproduced your issue using sample data and confirmed the behavior. The measures are returning the expected results Ending FTE provides the final available value for the period, whereas Avg FTE Month/Quarter/Year shows the appropriate aggregation for each respective level. Ending FTE gives the last available value in the period, while the Avg FTE Month/Quarter/Year reflect the correct aggregation at each level.

Hope this helps

Thank you.