Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Conversion

Hi,   1. Import data from the excel (attached), the datatype in power BI imported in Text Format. 2. Duplicated the column and changed the Data Type to Time and changed the format as below. ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi RajulShah,

 

In the attachment, i need the data in HH:MM:SS format in the Second Column.

 

Looking for a dax which can help me to convert Text to HH:MM:SS format.

 

Regards,

rajulshah's avatar
rajulshah
Resident Rockstar
6 years ago

But what does the value '506:17:23' mean?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Like 506 Hrs spentto resolve this any issue.

    • rajulshah's avatar
      rajulshah
      Resident Rockstar
      6 years ago

      Anonymous,

       

      But what should be the value in your calculated column for '506:17:23'?