Forum Discussion

SamanthBha's avatar
SamanthBha
Regular Visitor
3 years ago
Solved

Custom time Format in pbi

   Actually i am having the below data in excel i will use customise format ([hh]:mm) same i have to get in Power bi,    Can Anyone help me in this. Time Open to Close ([hh]:mm:ss) 946:10:49 ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi SamanthBha ,

    Please try to create a new column with below dax formula:

     

    Column =
VAR _a = [Column1]
VAR _hour =
    DIVIDE ( _a, 3600 )
VAR _id1 =
    FIND ( ".", _hour )
VAR _val =
    LEFT ( _hour, _id1 - 1 )
VAR _b =
    MOD ( _a, 3600 )
VAR _minute =
    DIVIDE ( _b, 60 )
VAR _id2 =
    FIND ( ".", _minute )
VAR _val1 =
    LEFT ( _minute, _id2 - 1 )
VAR _second =
    MOD ( _b, 60 )
RETURN
    _val & ":" & _val1 & ":" & _second

     

    Please refer the attached .pbix file.

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi SamanthBha ,

Please try to create a new column with below dax formula:

 

Column =
VAR _a = [Column1]
VAR _hour =
    DIVIDE ( _a, 3600 )
VAR _id1 =
    FIND ( ".", _hour )
VAR _val =
    LEFT ( _hour, _id1 - 1 )
VAR _b =
    MOD ( _a, 3600 )
VAR _minute =
    DIVIDE ( _b, 60 )
VAR _id2 =
    FIND ( ".", _minute )
VAR _val1 =
    LEFT ( _minute, _id2 - 1 )
VAR _second =
    MOD ( _b, 60 )
RETURN
    _val & ":" & _val1 & ":" & _second

 

Please refer the attached .pbix file.

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.