Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi.
So I am importing data from a .xlsx file where I have a column of minutes and seconds [m]:ss into Power BI, it's pulling through as text but when changed to Time in transform data it knocks the times out for example 207:38 imports as 0.144184028 and when changed to time becomes 03:27:38 which technically is correct but I need to see 207:38 [m]:ss.
Is there a way this can be done? I have looked on google but not be able to find an answer on this.
Many thanks
Solved! Go to Solution.
Hi @KaraWilson ,
As per my knowledge, there is no way to get a time format like your expectation on the end result yet. You can only keep it in text format.
Create a new column next to the column with a time value like " 3:27:38 " and then enter the following formula to get the expected result:
Hi @KaraWilson ,
As per my knowledge, there is no way to get a time format like your expectation on the end result yet. You can only keep it in text format.
Create a new column next to the column with a time value like " 3:27:38 " and then enter the following formula to get the expected result:
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |