dd:hh:mm:ss

[cham]

Hi,

After I upload the below excel sheet into power bi it will show an error in the highlighted row.

How can i change the data type in Power BI as dd:hh:mm:ss?

[v-yulgu-msft · Accepted solution]

Hi @cham,

To format data in "dd:hh:mm:ss", you can add a calculated column with below DAX:

Column = FORMAT(Table[TimeField],"dd:hh:mm:ss")

But, the data type will be converted to Text, as "dd:hh:mm:ss" is not a supported date/time type by Power BI.

Best regards,

Yuliana Gu

[cham]

Thank you so much I tried the way you explained

[cham]

Hi,

Thank you for your measure. 

But i upload the sheet into power bi and close and apply the sheet then it will show errors. 

I canadd a column using your meausure but the error in the edit query will remain same right?

How to avoide that?