time differe

[Anonymous]

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 

[Anonymous · Accepted solution]

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.

[Anonymous]

Super Working tnq @Anonymous 

[Dangar332]

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

[Anonymous]

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