Hello
When I have had the occasional success in grouping timestamps in a Power Pivot table, I typically group it based on hour and day. However, grouping the timestamps by hour will not be sorted in incremental order. This is a little strange, but whenever I ungroup, it is sorted in the correct order.
I have had it occured with multiple different csv files, so it isn't unique to a particular file.
What could be the cause of this and is there anyway to fix this?
Thanks
Edit: Added the individual files as needed. Since there might be a possibility that I might be doing something wrong in the Power Query, I have also attached the csv that I have been using.
Bookmarks