Forum Discussion

alexaffut's avatar
alexaffut
New Member
6 years ago
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...
Need Help
  • alexaffut's avatar
    alexaffut
    6 years ago

    I finally found the solution through the forum. Need to add Table.Buffer before the Table.Sort function to keep the sorting.

alexaffut's avatar
alexaffut
New Member
6 years ago

I finally found the solution through the forum. Need to add Table.Buffer before the Table.Sort function to keep the sorting.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

But this table.buffer will make your pbix huge like crazy, do you have any idea how to solve it?