Forum Discussion
Local Grouping / Index Issues
Hey guys, I have out-of-order source data that I'm performing a locally grouped index on. My index persists through every step except for a merge with another table (or, more specifically, the expan...
Hi BekahLoSurdo ,
Please try to update the code in group steps as blow:
= Table.Group(#"Sorted Rows", {"Qty"}, {{"Index Table", each Table.AddIndexColumn(_,"MinKey",1,1)}}) |
| = Table.Group(#"Sorted Rows", {"Qty"}, {{"Index Table", each Table.AddIndexColumn(_,"MaxKey",0,1)}}) |
If the above method not working, please provide your expected result with screen shot and explain more details on it. Thank you.
Best Regards
Rena