Forum Discussion
Sort grouped row by created on date in Order Ascending
I have created a column which shows all notes for each activity and the date each note was created. This has been grouped with another field from a different table. I am trying to sort this colum...
PwerQueryKees
Super User
Super UserThe Table.Group() does not preserve sort order or defines a sort order. So if you want your groups to be sorted, you do it AFTER the sort, but on each group individually.
Do the following just after your group by (check the step and field names first!):
= Table.TransformColumns(#"Grouped Rows",{{"Notes", each Table.Sort(_, {{"Latest Date", Order.Descending}})}})
I have added that command and I am now getting the following error.