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,
Sorry this is probably really easy but I'm trying to produce a table for management so they can see departments that are understaffed in advance. I have two tables and two lookups (Examples below).
I thought the calculation
Filled | |||||||||||
Assignment Info | Owning Unit | Person | Duty Date | Actual Work | Shift | Cost Centre | Fulfilment Type | Shift Type | Assignment No | Grade | |
Joe Bloggs - E on 18/04/2020 in Ward 21 (TW) | Ward 21 (TW) | Joe Bloggs | 18 April 2020 | 7.5 | Early (E) | Ward 21 (TW) | Agency | Day | Band 5 RN | ||
UnFilled | |||||||||||
Valid Date | Owning Unit | Shift Type | Planned Start Date | Planned End Date | Start Time | End Time | Work Time | Rest Time | Grade | Grade Type | Grade Type Category |
11-May-20 | Clinical Admin Unit - Head and Neck | Day | 11/05/2020 09:00 | 11/05/2020 17:00 | 7.5 | 0.5 | A&C | A&C | - | ||
LU Unit | |||||||||||
Healthroster Unit | Cost Centre | Org L2 | Org L3 | Site | |||||||
Chief Executive | AA102 | Test | Corporate and Support | Test | |||||||
LU Grade | |||||||||||
Grade | Staff Group | Secondary Grade | |||||||||
A&C | Administrative and Clerical | A&C |
Hi @scott3387 ,
Do the "Filled" and "Unfilled" tables have a relationship?
According to the sample data, the calculated result is just a percentage value.
You could show the expected result here.
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 |
---|---|
111 | |
94 | |
92 | |
84 | |
69 |
User | Count |
---|---|
162 | |
129 | |
126 | |
106 | |
98 |