Skip to main content

    Power BI

    New

    Display seconds in hh:mm:ss format

    Vote (31) Share
    Mike's profile image

    Mike on 02 Jul 2016 01:40:40

    Allow creating measures based on values in seconds (i.e AHT, Hold Time ,etc typical call center metrics), but display the result formatted as hh:mm:ss.

    Comments (1)
    Mike's profile image Profile Picture

    0640b67e 2e2a-4e88-a7a4-d358211a6cf4 on 05 Jul 2020 23:31:51

    RE: Display seconds in hh:mm:ss format

    '@Bill Hoenig: this approach does not work for larger numbers, e.g. TIME(0, 0, 86300) throws error (An argument of function 'TIME' has the wrong data type or the result is too large or too small.)