Duration between Date Time

[Anonymous]

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.

[nandic · Accepted solution]

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