Hello
I have a Power Query sample in which I am sorting and filtering out data before placing into a Pivot table. Most of the data have associated timestamps attached to it. More often than not, I am unable to "group" the timestamps into hours/days/months, etc. from a resulting power pivot table. I have tried removing all of the nulls, but is there something in the query that I need to do to always ensure that my timestamps can group?
I have tried all sorts of methods, including removing and adding again to deleting the worksheet and reloading the query into a new Power Pivot table and they have all ended with the same results.
I have attached a sample folder with my existing Power Query and a sample data set that I'm querying against.
Any help would be appreciated.
Thanks
I have a Power Query sample in which I am sorting and filtering out data before placing into a Pivot table. Most of the data have associated timestamps attached to it. More often than not, I am unable to "group" the timestamps into hours/days/months, etc. from a resulting power pivot table. I have tried removing all of the nulls, but is there something in the query that I need to do to always ensure that my timestamps can group?
I have tried all sorts of methods, including removing and adding again to deleting the worksheet and reloading the query into a new Power Pivot table and they have all ended with the same results.
I have attached a sample folder with my existing Power Query and a sample data set that I'm querying against.
Any help would be appreciated.
Thanks
Attachments
Last edited: