Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello,
I am trying to calculate each employees percentage of a full-time employee they are working. By employee, by month, I pull their actual hours worked vs what full-time hours are for that type of employee, and divide to find the percentage of Full-time they are.
For example, I have an Anesthetist that worked total 60 hours in April, based off of 2 paychecks. A full-time Anesthetist should work 80 hours per paycheck, times 2 paychecks, 160 hours. So 60/160, this person is .375 Full time employee
Actual hours is given - Hours paid on Result
Expected Hours per paycheck:
Solved! Go to Solution.
So, it looked like it was doubling or tripling the FTE Status by Employee (multiplying by number of checks):
So I took Check Date out of the formula and it looks like it's working now:
You need to iterate over a summary table using the same columns as in the table visual, e.g.
Expected Hours Total =
SUMX (
SUMMARIZE (
'Per Diem Pay Slips',
'Per Diem Pay Slips'[Employee ID],
'Per Diem Pay Slips'[Check date]
),
CALCULATE (
MIN ( 'Per Diem Pay Slips'[Expected Hours Per Pay Period] ) * [Check Count]
)
)
Wow, thank you so much, that worked. But now the FTE Status is not summing, do I have to do something similar?
Yes, its the same pattern
FTE Status =
SUMX (
SUMMARIZE (
'Per Diem Pay Slips',
'Per Diem Pay Slips'[Employee ID],
'Per Diem Pay Slips'[Check date]
),
CALCULATE (
DIVIDE (
SUM ( 'Per Diem Pay Slips'[Hours Paid on Result] ),
[Expected Hours Total]
)
)
)
So, it looked like it was doubling or tripling the FTE Status by Employee (multiplying by number of checks):
So I took Check Date out of the formula and it looks like it's working now:
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
110 | |
59 | |
57 |