How to extrapolate weekly data into daily data, taking account of absences

[Daniish]

I receive a monthly export of data showing staff rotas and I want to highlight the % availability of Duty Officers on a Role in any particular week, by taking account of any planned absences of staff that are recorded as comments within the data.

I have been able to extract the comments about absences and record them in 2 additional columns giving the date range that this applies to. Now i need to extrapolate all this weekly data into daily data with a separate row for each Duty Officer on each day, with the absences included in the Value column as 'Unavailable'.

This is what the current weekly data looks like:	..and this is how i need it to look with lots of extra rows:

Can anyone show me how to do this?

[amitchandak · Accepted solution]

@Daniish , Refer this file a new table is created with all dates between date. see if that can help

https://www.dropbox.com/s/97ff7141d5atppy/daysbetweendates.pbix?dl=0