Distributing durations across different days

[Anonymous]

Hi,

I am almost certain there is a post on here that I haven't found just yet that covers this so if you can help please point me in that direction...

I need to separate out a duration of an event over a number of days and allocate the time to the actual day it occurred on. 

So start date = end date no problem

start date 02/02/20 23:44:13 - endate 02/03/20 00:01:00 means I need to have the 1 minute as 2/320 and the rest accounted for in 2/2

Then with a 3 day gap I need the middle day with the full timings and the amount of time allocated for the other two days... and so on..

If I can get to either secs or days:hours:mins:secs I can convert across.

Is this something I can solve in DAX?

[Greg_Deckler · Accepted solution]

@Anonymous - I have done something similar:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Hour-Breakdown/m-p/625085#M306

Also, here are some links to dealing with durations
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486
https://community.powerbi.com/t5/Quick-Measures-Gallery/Duration-to-Seconds-Converter/m-p/342279#M92