Measure to calculate time duration for 24+ hour periods

[eddd83]

I have the following data

Event	Start time	End time	Duration (HR)
A	Jan 1 1:00 PM	Jan 1 2:00 PM	1
B	Jan 2 1:00 PM	Jan 2 2:00 PM	1
C	Jan 2 1:00 PM	Jan 4 1:00 PM	48

I want to produce the following with a measure

Date	desired measure (hr)
Jan 1	1
Jan 2	12
Jan 3	24
Jan 4	13

Help?

[Noah_Mom]

Hi. I also need help with this. Have you found the solution?

[Greg_Deckler · Accepted solution]

@eddd83 OK, I'll bite, how are you arriving at those numbers in your expected results? Do you need something like Overlap for computing minutes with time intervals? Attached below sig. Maybe Open Tickets? https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364#M147

[eddd83]

Your ticket file is not exactly what i need, but i think it should be a good template that I can start with. Thank you.

[Greg_Deckler]

@eddd83 OK, let me know if you need assitance, just @ me. 

[eddd83]

sorry for the poor formatting resulting in the poor readability. I can't figure out how to fix it

Event A only happens in Jan 1 for 1 hour. 

Event B only happens in Jan 2 for 1 hour.

Event C occurs in Jan 2 from 1pm to midnight (11 hours)

then in jan 3, it occurs all day (24 hours)

then in jan 4, it occurs from midnight to 1pm (13 hours)

Therefore:

Jan 1 - 1 hour

Jan 2 - 12 hours total = 1 hour (event B) + 11 hours (event C) 

Jan 3 - 24 hours (event C)

Jan 4 - 13 hours (event C)

[eddd83]

here is a picture 

[Greg_Deckler]

@eddd83 Right, so it is a variation on both of the solutions I presented, glad to know it is an actual date/time column, what you posted as sample data was not. I'll have to mock it up, these things tend to get interesting. Have a look at the solutions in my first response to get an idea what you are in for.