How to control the order when grouping

[yishenhui]

Hi,

When I grouping, is it poosible to control the order of aggregation? As below two screenshots, the first step, the data is already sorted. But when I grouping and want to combine those string together with this order, it doesn't. Any idea how to get it?

Thanks

[Payeras_BI · Accepted solution]

Hi @yishenhui ,

I would try this:

Table.Group(Table.Buffer(SortTableAgain),...

[yishenhui]

Hi J.Payeras,

I applied a sorting  in the source date loading. After that, the issue disappeared even I removed the sorting. I cannot re-produce the issue again to test your suggestion. But I have read the articles about Table.Buffer and would accept it as Solution.

Thanks.