Cover by Day

[SHILL]

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

[v-xiaotang]

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.

[amitchandak]

@SHILL , check if the measure way discussed in this blog can help

https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...

[SHILL]

Thanks Amit however I cannot seem to make it work with that measure