Forum Discussion
Power Query - Error while rounding off time
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.
My bad. I forgot formatting doesn't round. In that case you were on the right track. The answer you're looking for is in this post: https://community.powerbi.com/t5/Desktop/How-to-round-minutes-in-time-to-the-nearest-hour/td-p/476432
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
I just tried the Dax solution. Do you know a way to check if there are errors in that? From the filter dropdown, i cant see any errors. Anonymous
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.