Forum Discussion

Shayz2402's avatar
Shayz2402
Frequent Visitor
4 years ago
Solved

Duration is reflecting in Time Format AM/PM

Hi,   I have a Data on Google sheet which is in Duration Format and when I link this sheet with Power Bi Data Source it is reflecting in Time Format AM/PM   I would really appreciate if anyone ca...
  • SpartaBI's avatar
    4 years ago

    Shayz2402 you can PM me and we could do a quick zoom to look together if you want. Hard to see from the sceenshots

  • SpartaBI's avatar
    SpartaBI
    4 years ago

    @ this is the code:

     

    Five 9 Total = 
    VAR _value = SUM(Sheet7[Five 9 Login TIme])
    VAR _hours = DATEDIFF(DATE(1899,12,30),_value,DAY) * 24 + HOUR(_value)
    VAR _minutes = MINUTE(_value)
    VAR _seconds = SECOND(_value)
    RETURN
        _hours & ":" & _minutes & ":" & _seconds

     





          

    Showcase Report – Contoso By SpartaBI