Forum Discussion
Unpivot - [DataFormat.Error] We couldn't convert to Time
Thank you for the attempt.
I managed to find the issue.
4 errors that happend in column that was supposed to be time value. Calculation in that column caused cells to be over 1, immediatelly preventing it to be converted to time. Once i fixed these errors, unpivot worked like a charm :)I realy appreciate your asistance.
Regards
Filarap
Thank you d_gosbell,
I already have 30 minute buckets created. Sorry dont have access to file at the moment, so i will replicate in table below.
Table below shows data before i did unpivot (Screenshot from initial post).
| Duration(min) | Starting Time stamp | Ending Time Stamp | Starting Bucket | Ending Bucket | 15:00 | 15:30 | 16:00 | 16:30 |
| 48 | 15:32 | 16:20 | 15:30 | 16:00 | 0 | 28 | 20 | 0 |
Starting time stamp is taken from date/time cell from raw data.
I have create columns showing exact time spent in each interval. This was done using nested ifs.
No issue with apply before unpivot. As soon i do unpivot, and try to apply, i get error above.
Or am I misunderstanding your formula?
Regards
Filarap
Super UserOh I thought your raw data was different.
But i'm not able to replicate your error. I pasted your example data into a new Power BI report, selected all the columns that were not time buckets then chose the UnPivotOtherColumns transformation which produced the PowerQuery step below
Table.UnpivotOtherColumns(#"Changed Type1", {"Duration(min)", "Starting Time stamp", "Ending Time Stamp", "Starting Bucket", "Ending Bucket"}, "Attribute", "Value")
This unpivoted the example data without an error. Are you able to share some example data (does not have to be real data) which reproduces your issue.
ps. Sorry for the late reply it appears that the forum notifications have stopped working
Thank you for the attempt.
I managed to find the issue.
4 errors that happend in column that was supposed to be time value. Calculation in that column caused cells to be over 1, immediatelly preventing it to be converted to time. Once i fixed these errors, unpivot worked like a charm :)I realy appreciate your asistance.
Regards
Filarap