Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

time differe

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's avatar
    Anonymous
    2 years ago

    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's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    Anonymous
    Not applicable
    2 years ago

    Super Working tnq Anonymous