Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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")
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")
Thank you so much I tried the way you explained
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |