I am using Power Query to organize, clean and sort data that have attached timestamps. More often than not, when I'm transforming the data into a Pivot Table, I'm unable to group my date timestamps into my desired groups of hours/days/months. However, this happens randomly, so I'm not sure if it is something that I'm doing in Power Query that messes things up.
I have attached my sample zipped folder.
Edit1: I have posted a similar question on another forum, ExcelGuru. Here's the link: https://www.excelguru.ca/forums/show...date-timestamp