Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
105 | |
98 | |
38 | |
37 |
User | Count |
---|---|
152 | |
125 | |
75 | |
74 | |
63 |