Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
User | Count |
---|---|
120 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
181 | |
85 | |
67 | |
62 | |
55 |