Forum Discussion

rigamonk's avatar
rigamonk
Regular Visitor
8 years ago
Solved

Seconds wont convert over from string using format function

I have a table with dates in DateTime format: When I try to break them down to s string using Format, the time always comes back as "12:00:00 AM" Heres the DAX I am using: Harvest Hours = Fo...
Tutorial Requests
  • v-cherch-msft's avatar
    v-cherch-msft
    8 years ago

    Hi rigamonk

     

    You may use DATEDIFF Function (DAX) to get the total time between the two. Show DAX as below:

     

    Harvest Hours =
FORMAT ( MAX ( 'Abattoir RecordScan'[EventDate] ), "MM/dd/yyyy hh:mm:ss AM/PM" )

     

    Regards,

    Cherie

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi rigamonk

 

You may use DATEDIFF Function (DAX) to get the total time between the two. Show DAX as below:

 

Harvest Hours =
FORMAT ( MAX ( 'Abattoir RecordScan'[EventDate] ), "MM/dd/yyyy hh:mm:ss AM/PM" )

 

Regards,

Cherie