Forum Discussion
Solved
Power Query - Error while rounding off time
Hi Team, I wanted to round off my time column into the nearest hour in Power Query and it worked for most of the data, but about 20% of the data has errors now and I am not able to understand why...
Well you can use the DAX to create a caluclated column on your original table or recreate the table as a visual and add a column for the measure. Should make it fairly easy to determine if there were any errors.
Haha the code I used was exactly from that link! But its giving me errors on some lines.
Haha I see that now. Have you tried the DAX solution instead of the M option?
If it has to be M try this thread: https://community.powerbi.com/t5/Desktop/Round-Down-to-Nearest-30-Minute-Interval-Query-Editor/td-p/514248