topic Re: time differe in DAX Commands and Tips

time differe

Anonymous — Mon, 18 Mar 2024 18:08:27 GMT

by using date difference 11-03-2024 16:00:00 -11-03-2024 13:20:08 expected is 00 02:39:52 but caming as 30 02:39:52 how to over come this and why it showing 30 days

Re: time differe

Dangar332 — Mon, 18 Mar 2024 19:14:09 GMT

hi, Anonymous

use datediff( ) fuction

like below

column= datediff(table[last updated date],table[created date],hour)

if you want it in minute then simply change HOUR to MINUTE

Re: time differe

Anonymous — Mon, 18 Mar 2024 19:33:47 GMT

Tnq for replying

But instead of datediff we can also do difference in power query but I want to be except the same output value to find the average date and time for all the records but it showing 30

Re: time differe

Anonymous — Tue, 19 Mar 2024 02:36:51 GMT

Hi Anonymous ,

I made simple samples and you can check the results below:

Measure = var _D1 = DATEDIFF(MAX('Table'[Created Date]),MAX('Table'[Updated Date]),DAY) var _D2 = MAX('Table'[Updated Date]) - MAX('Table'[Created Date]) RETURN COMBINEVALUES(" ",_D1,FORMAT(_D2,"hh:mm:ss"))

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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

Re: time differe

Anonymous — Tue, 19 Mar 2024 05:15:11 GMT

Super Working tnq Anonymous