Forum Discussion

JeroenItho's avatar
JeroenItho
New Member
9 years ago
Solved

Calculate Duration

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

Need Help
  • MFelix's avatar
    MFelix
    9 years ago

    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

1 Reply

  • MFelix's avatar
    MFelix
    Super User
    9 years ago

    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