Calculate Duration

[JeroenItho]

Hi There,

I’m pretty new in Power Bi and I’m trying to calculate the duration and days from a single start time.

For example the start time is: 11-5-2017 09:48:56

Finally I would like to get a table like this.

Mtime	PowerW	Duration	Days
11-5-2017 09:48:55	2300	-00:00:01	0
11-5-2017 09:48:56	2300	00:00:00	1
11-5-2017 09:48:57	0	00:00:01	1
….
13-5-2017 09:48:57	2300	00:00:01	3

I hope someone can explain me how to make this.

example

[MFelix · Accepted solution]

Hi @JeroenItho,

Try to add two columns:

Time = MIN('Start'[StartTime])-'Power'[Mtime]

Format this as a time measure

days =
IF (
    MIN ( 'Start'[StartTime] ) > 'Power'[Mtime],
    0,
    DATEDIFF ( MIN ( 'Start'[StartTime] ), 'Power'[Mtime], DAY ) + 1
)

This should work.

Regards,

MFelix