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
Hi All, I have the below table that lists colleagues on annual leave and which colleague is covering that person and I am trying to get to different outcome from this table but cant make it work
This is the table I have:
Colleague | First Day of hols | Last day of hols | Whos Covering |
Colleague 1 | 22/08 | 26/08 | John |
Colleague 2 | 15/08 | 26/08 | Paul |
Colleague 3 | 24/08 | 03/09 | Julie |
First outcome I need is -
A list by day, of which colleagues are on annual leave - Such as the below;
Monday | Tues | Wed |
Colleague 1 | Colleague 1 | |
Colleague 2 | Colleague 2 | Colleague 2 |
Colleague 3 |
The second outcome I am trying to get is how many covers a person is doing each day - Such as below:
Colleague Covering | Mon | Tue | Wed |
JOHN | 1 | 1 | |
PAUL | 1 | 1 | 1 |
JULIE | 0 | 0 | 1 |
Thanks in advance for any help
Hi @SHILL
Thanks for reaching out to us.
You need to first create a table of employees' relationships with working days, and then calculate count
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
@SHILL , check if the measure way discussed in this blog can help
Thanks Amit however I cannot seem to make it work with that measure
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 |
---|---|
31 | |
16 | |
14 | |
14 | |
10 |