topic Re: Time duration in power bi in DAX Commands and Tips

Time duration in power bi

Tahmineh1989 — Fri, 23 Jun 2023 11:25:08 GMT

How calculate the difference time between 11:54:00 PM and 12:09:00 AM in power bi?

Re: Time duration in power bi

ppm1 — Fri, 23 Jun 2023 11:48:22 GMT

If the end time is earlier in the (next) day, you can +1 to the difference. This article may have some good other info on working with times/durations in Power BI.

Calculate and Format Durations in DAX – Hoosier BI

Pat

Re: Time duration in power bi

Tahmineh1989 — Fri, 23 Jun 2023 12:47:04 GMT

Re: Time duration in power bi

v-zhangti — Mon, 26 Jun 2023 03:03:41 GMT

Hi, Tahmineh1989

You can try the following methods.

Column:

MINUTE = DATEDIFF([Time1],[Time2],MINUTE)

Is this the result you expect?

DATEDIFF function (DAX) - DAX | Microsoft Learn

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Time duration in power bi

Tahmineh1989 — Mon, 26 Jun 2023 09:31:50 GMT

Hi,

I did what you said. But the value of -1425 is wrong. The duration between 11:51:08 PM on 22 June and 12:06:08 AM on 23 June is 15 min. Why does it show this huge amount?

Re: Time duration in power bi

v-zhangti — Fri, 30 Jun 2023 07:38:03 GMT

Hi, Tahmineh1989

You can try the following methods.

Column:

LongTime1 = [Date]&" "&[Time1]

LongTime2 = Var _lastdate=MAXX(FILTER('Table',[LongTime1]>EARLIER('Table'[LongTime1])),[Date]) Return IF(_lastdate=BLANK(),BLANK(),_lastdate&" "&[Time2])

Change the format of the column from text to datetime.

Diff = DATEDIFF([LongTime1],[LongTime2],MINUTE)

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.