Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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:
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
96 | |
90 | |
79 | |
67 |
User | Count |
---|---|
151 | |
121 | |
111 | |
107 | |
95 |