Forum Discussion
Solved
Sort is not applied once column is expanded
Hi I have this Connection Query that contains a column with a list using this formula : let
Source = Table.NestedJoin(#"Nom Soumission", {"OV_OBJECTPART"}, #"M-Add02: ID Add+M-Add01", {"O...
I finally found the solution through the forum. Need to add Table.Buffer before the Table.Sort function to keep the sorting.
It isn't a bug, but to the best of my knowledge, sorts do not survive a merge/expand operation. The Table.ExpandTableColumn doesn't see to have any parameter that would sort either. You'd need to apply sorts after the expansion.
I finally found the solution through the forum. Need to add Table.Buffer before the Table.Sort function to keep the sorting.
But this table.buffer will make your pbix huge like crazy, do you have any idea how to solve it?