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.

4 Replies

  • Dangar332's avatar
    Dangar332
    Resident Rockstar
    2 years ago

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

      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 

  • 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