Hi,
I’m having trouble calculating the total FTEs by quarter using a Pivot Table from Apr-June—it’s not giving the correct results. I’m wondering if using DAX would be a better approach for this.
Specifically, I want to calculate the FTE for Architecture based on the formula:
Total Hours (1033) ÷ (40 hours × 13 weeks)
Could you advise on the best DAX measures to use for this kind of calculation or what could be the steps I can follow to get the correct calculations?
Thank you in advance for the help! I've been stuck with this for a week
@riny thank you. I have splicers connected to the Pivot. Will it dynamically work if I go back to choosing per month
I want the report to be dynamic where if I select the month in the slicer, it will show the correct FTE total for the month and if I select 3 months in the slicer, it will show the correct calculation. So far it is not giving the correct calculations.
Thanks in advance for the response! 🙂
So you want to calculate FTE's based on whatever period you select? One month, a quarter, Feb to Maj or whatever? Not sure. Can you share an anonymised file?
