Forum Discussion
Solved
Power Query Table.Group Doesn't Keep Sort
I'm new to Power BI, so any help would be appreciated. I've gotten pretty far in my query building, but I'm stuck. Essentially I wanted to create a unique Index based on "PHN Combo" (i.e. PHN Combo...
I seem to remember coming across this in the past and the "trick" was to add a normal index column after doing the sort, then after grouping you can delete the index column
Adding the index step seems to force Power Query to keep the sort order
Give it a go and let us know how you get on
I seem to remember coming across this in the past and the "trick" was to add a normal index column after doing the sort, then after grouping you can delete the index column
Adding the index step seems to force Power Query to keep the sort order
Give it a go and let us know how you get on
- Seems to have worked for me! Thank you!
- Very helpful tip! Worked beautifully.
Wyn Hopkins Love in the time of corona! thank you.
- You beautiful person...It worked! thank you!
