Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Duration between Date Time

Hi Power BI Community!

Is there a way to show the duration time between for example 01.01.2020 10:10:15 and 10.01.2020 20:10:15 (Form Date time)

So in this example the result should be 9 Days 10 hours

I did seperate date and time and tried to calculated something useful but I failed.

Your help is needed and appreciated.

Need Help
  • nandic's avatar
    nandic
    5 years ago

    Hi Anonymous ,
    There is option in Power Query to add new column (Custom column).
    In formula just type: [End date column] - [start date column]
    It returns it in format   days:hours:minutes.

    Regards,
    Nemanja Andic

1 Reply

  • nandic's avatar
    nandic
    Resident Rockstar
    5 years ago

    Hi Anonymous ,
    There is option in Power Query to add new column (Custom column).
    In formula just type: [End date column] - [start date column]
    It returns it in format   days:hours:minutes.

    Regards,
    Nemanja Andic