Mcode inside "Text.Combine" not responding to a sort

[Guitarmageddon]

Hey folks, I have the below step in my query which is taking the dates, grouped by the four fields in the "Table.group" and its using "text.combine" to put all of the "run dates" into one cell. I added a "list.sort" function inside the text.combine, but in the output, its still apparently not following the sort. Is this something about date/text formats?

Here is the code

= Table.Group(#"Renamed Columns", {"DUNS","GEN", "GEN_NAME", 
"SHIPPED_TO_SITE","MIN_NOTES"}, {{"Run Occurences", each Table.RowCount(List.Distinct(_[RUN_DATE])), Int64.Type},
{"Order Dates", each Text.Combine(List.Sort(List.Distinct(_[RUN_DATE]),Order.Ascending),", ")}
}
)

Here is what I see in the output, for example, youll see 9-4 there as the last date when I would expect 9-28.

 

[JEC]

Can you post the table? Probably convert to number, sort the list, then transform back to date format. Finally, combine them

 

[Guitarmageddon]

Can you post the table? Probably convert to number, sort the list, then transform back to date format. Finally, combine them

Unfortunately no luck messing with this., Im wondering if this is an issue that Table.Buffer can resolve? I tried putting it into the various steps, but not sure where I should be using it. Any thoughts?

 

[GraH]

Maybe you can try

Text.Combine(List.Transform(List.Sort(_[RUN_DATE], each Text.From(_), Order.Ascending)), ", ")