Forum Discussion
FTE calculation
Hi all, I am looking for a DAX statement which returns the number of FTE given the context. For one month only, I have a solution (*), but for periods longer than 1 month I would like the measure...
Anonymous
Your last post was extremely helpful.
Thank you very much for the expected results.
So you can combine these measures into one measure using variables. However, I've left them separate to show step by step. This is especially useful when testing pieces of DAX within the table visual results.
Step 1) Create a measure to get the Billable Hours
Step 2) Create a measure to get the Workable Hours
Step 3) Create a measure to Divide.
Billable Hours / Workable Hours
Results:
Regards,
Nathan
This seems to work properly! Thanks Nathan!