Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register 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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
85 | |
66 | |
51 | |
45 |
User | Count |
---|---|
216 | |
89 | |
82 | |
66 | |
57 |