Convert date into day,hour and minute

[Anonymous]

Hi,
in need to create a new field to show the  number  of days and   number  of  hours, Minutes and Seconds Between two Dates  D1 and D2 , such as  below  data

              D1                                          D2                                        new field

 Jul 09 2019 13:47:17       --    Jul  09 2019 16:22:13             0 DAY :  3 Hours :  25 Mintuse :  4 Second 

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

I create a measure to implement it. You can have a try.

Measure =
DATEDIFF ( MAX ( Table1[Date 1] ), MAX ( Table1[Date 2] ), DAY ) & " Days : "
    & DATEDIFF ( MAX ( Table1[Date 1] ), MAX ( Table1[Date 2] ), HOUR ) & " Hours : "
    & MINUTE ( FORMAT ( MAX ( Table1[Date 1] ), "hh:mm:ss" ) )
        - MINUTE ( FORMAT ( MAX ( Table1[Date 2] ), "hh:mm:ss" ) ) & " Minutes : "
    & SECOND ( FORMAT ( MAX ( Table1[Date 1] ), "hh:mm:ss" ) )
        - SECOND ( FORMAT ( MAX ( Table1[Date 2] ), "hh:mm:ss" ) ) & " Seconds"

Best Regards,

Xue Ding 

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