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
rajulshah's avatar
rajulshah
Resident Rockstar
6 years ago

Hello Anonymous,

I saw the data in the file uploaded by you.

The data in the column is invalid for the Time datatype.

Can you explain further about the column?

  • 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.