Forum Discussion

Sajid02's avatar
Sajid02
Icon for Helper I rankHelper I
3 years ago

Converting Decimal time to Time format HH:MM:SS

Hi Folk ,    Got stuck in one place wherein i want to convert decimal time values into correct time format like HH:MM:SS Please find below snip :- Dax I have tried is :-  ODI S...
Need Help
onurbmiguel_'s avatar
onurbmiguel_
Icon for Power Participant rankPower Participant
3 years ago

Hello Sajid02 

 

The value ODI SSC actual is in hours? 

Example, the value 2.00 is 02:00:00 ? 

 

Can you share a pbix with some dummy values? 

 

Best regards

Bruno Costa | Solution Supplier

 

Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 👍

Take a look at the blog: PBI Portugal 

 

  • Sajid02's avatar
    Sajid02
    Icon for Helper I rankHelper I
    3 years ago

    Hi onurbmiguel_ 

    The Value is in the form of seconds like 

    0.35  is 35 seconds 
    1.25 is 1 minute and 25 seconds and so on

    • onurbmiguel_'s avatar
      onurbmiguel_
      Icon for Power Participant rankPower Participant
      3 years ago

      hello Sajid02 

       

      One other question , so if you have 1,50 it qill be 00:01:50 ? and if you have 1,90 ?

       

       

      Best regards

      Bruno Costa | Impactful Individual

       

      • Sajid02's avatar
        Sajid02
        Icon for Helper I rankHelper I
        3 years ago

        Hi 

        If i have 1.90 then it should be 00:02:30 sec