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

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