Date Time Difference

YusufGillani · November 26, 2020, 7:37am

Hi,

Can someone please tell me how I can create a Date Time Difference between these columns? Is it possible to do this in the Query Editor. Is it possible to do a Dax measure for this as well?

Delivery App.pbix (484.2 KB)

Thanks

Yusuf

AntrikshSharma · November 26, 2020, 9:39am

@YusufGillani First select the column from which you want to subtract and then select the other column.

Melissa · November 26, 2020, 9:47am

Hi @YusufGillani,

Should you want the difference in another time unit like Minutes for example.
Start by calculating the difference in duration.

Select that column and choose: Transform, Duration, Total …

I hope this is helpful.

alexbadiu · November 26, 2020, 11:18am

@Yusuf, yes, you can create a Date & Date Time Difference using DAX.

Diff Days =
VAR _DateArrived = MAX('Delivery Data'[Date Arrived])

VAR _DateLeft = MAX('Delivery Data'[Date Left])

RETURN

DATEDIFF(_DateArrived,_DateLeft,DAY)

// You can replace DAY by Hour, Minute, Month, Quarter, Second, Week,Year