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 ...
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

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