Forum Discussion
Values in table change when expanding table column
Hello, Didn't find anything via the search function... I'm running a query with the following source code: let
Quelle = Latest_Tickets,
#"Gefilterte Zeilen" = Table.SelectRows(Quelle, ea...
Hi Anonymous ,
there is no native sort order in Power Query and the joins do often reorder the rows.
If you want to keep a sort order from the original load, you have to add an Index-column right at the beginning after which you can sort later on, once PQ has changed the row.
But make sure to buffer the sort, as the sort order might not be kept otherwise: https://community.powerbi.com/t5/Community-Blog/Bug-warning-for-Table-Sort-and-removing-duplicates-in-Power/ba-p/810390
Nathaniel_C
Community Champion
Community ChampionHi Anonymous ,
Let me suggest that you reach out to ImkeF who is a genius with queries!
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel