Generate dates in between dates to have downtime hours in between

[Kurdapyo_pogi]

Hi! Everyone. Hope you are all well!

Need a help from you all.

I have table of equipment downtime with start and end date/time. 

Would like to have a results like as show below. Result that generates a dates in between so I can have the downtime hours in between.

Thank you and appreciate your kind help.

[Kurdapyo_pogi]

Thanks a lot @amitchandak 

[amitchandak · Accepted solution]

@Kurdapyo_pogi ,

Between Dates - Dates between

Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM
https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...

Tables way
https://amitchandak.medium.com/dax-get-all-dates-between-the-start-and-end-date-8f3dac4ff90b
https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2