Sort grouped row by created on date in Order Ascending

phull543 

Split the column into 2 columns : Date and Note, and sort by the Date. 

You can sort by other column(s) first to maintain some other order you might need before sorting by this new Date column.

Phil

I have tried to do that but it take the first date which is the oldest date and i am trying to sort by newest. 

Hi phull543 ,

Before Grouping, sort the date then group. Will that work for you?

phull543 Use Lines.FromText

And then Sort by extracting the date part

Ascending

Descending

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUTIyMDLRNTDVNTRT8EgsKKhUcMosKslISayMyQNLGRrpGhsqRKYmFim45qVABQ0MgUjBL7UcLAETNNc1tFDwTSwqykxMT1VwzMvLLEstKk4sqlSKjQUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ID = _t, Events = _t]),
    AddedCustom = 
        Table.AddColumn (
            Source, 
            "Custom", 
            each List.Sort (
                Lines.FromText ( [Events] ), 
                {
                    each Date.FromText ( Text.Start ( _, 10 ), [ Format = "yyyy-MM-dd" ] ), 
                    Order.Descending
                }
            )
        )
in
    AddedCustom

The 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}})}})