Calculate sum of hours falling within a selected month for transactions spanning multiple months

[Noddy]

Greetings of the day to all you brainy folks 🙂
I am a basic user of powerquery, do not have powerBI installed. I could use your help with this issue I am struggling with.

I have a list of transactions (thousands of rows) that have an outage start time and end time, most of them spanning over multiple months.

Number	Outage Began	Outage Ended
INC2536	1/4/2023 4:01	5/4/2023 9:01
INC2537	1/4/2023 4:01	1/4/2023 9:01
INC2538	2/8/2023 9:46	4/15/2023 11:01
INC2539	3/24/2023 16:35	5/24/2023 20:28
INC2540	5/28/2023 16:21	7/3/2023 17:38
INC2541	6/4/2023 8:25	6/4/2023 9:42
INC2542	6/17/2023 9:25	6/17/2023 13:00
INC2543	6/17/2023 9:25	6/18/2023 11:33
INC2544	6/17/2023 9:25	7/18/2023 11:33

I need to calculate the count of Incidents and the sum of outage hours that fall within a certain month, say Apr'23. In other words, if I filter my Pivot to Apr'23, it should only give me the count and sum for the Incidents that have some of the time during Apr'23.
Thanks very much in advance

[Noddy]

hello @Ruba , thanks very much for your reply.
Yes, you are correct on count of number but in sum of duration I should get 1861.47569444438 hours

I will try to explain more (sorry, English is not my first language)...
There are 3 Incidents that had days of outage falling during April (INC2536, INC2538 and INC2539).

INC2536 and INC2539 were down for all 30 days of April  (because outage started before April and ended after April) so their outage hours in April should be 750+750....(30*24)
Outage for INC2538 started before April and ended at 4/15/2023 11:01:00 AM so it had 14.45903935 days or 361.4759838 hours of outage time in April
Adding the hours for those 3 Incidents gives us 1861.4759838 hours

[rubayatyasmin]

Do you want something like image below? I am not sure I got your question.