Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Distributing durations across different days

 

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?