Forum Discussion
FTE calculation
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
WinterMist the table presented earlier is my source data. The output of the measure should return the highlighted values below. With the current DAX statement I get wrong FTE totals.
So the formula needs first needs to sum the hours in the filtercontext (i.e. Jan-Feb). For Employee A, billable hours, this is 160+160 =320 hours. Next, the measure needs to divide the sum by 176+160=336 workable hours for the month.
And also, for example, for total billable hours Jan (160+172+120) + Feb (160+148+152) = 912, the sum needs to be divided by 176+160=336 workable hours.
Impactful IndividualAnonymous
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