Issue with availability of incidents

[Wokster]

Goodafternoon,

I have 3 tables in my powerBi report;

Calldate 

Enddate

Unique ID

Some of the calldates are 17 november 2022 where the enddate is 5 January 2023.

I want the availability of December 2022 if i try to give me the hours i should get 728 hours offline but i don't know how to do this in my report.

I have mulitple Unique ID's and multiple dates some are 5 December 2022 until 10 December 2022.

Thank for your help,

Kind regards,

[amitchandak]

@Wokster , refer if these can help

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.mediumcom/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