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...
Need Help
Shayz2402's avatar
Shayz2402
Frequent Visitor
4 years ago

Request everyone to please Help me.

  • SpartaBI's avatar
    SpartaBI
    Icon for Community Champion rankCommunity Champion
    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

     


    In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.


    SpartaBI Logo

    Visit SpartaBI website   Visit SpartaBI Linkdin   Visit SpartaBI Facebook

    Showcase Report – Contoso By SpartaBI

    • Shayz2402's avatar
      Shayz2402
      Frequent Visitor
      4 years ago

      Thanks a lots SpartaBI You are an very knowlagable and amazing Person. You safe my day and also it means a lot to me.

      Thanks a Lot and Much appreciated your help and support.
      Looking forward to work with you.

      • SpartaBI's avatar
        SpartaBI
        Icon for Community Champion rankCommunity Champion
        4 years ago

        Shayz2402 MY PLEASURE!! 🙂