Forum Discussion

BekahLoSurdo's avatar
BekahLoSurdo
Resolver IV
6 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

  • BekahLoSurdo's avatar
    BekahLoSurdo
    Resolver IV
    6 years ago

    Anonymous,

    If I partition by Qty, each line will have an Index value of 1 instead of the correct 1-8. I am partitioning by Part because I need a local index for each Part in my data. I am working on another example now. Thanks!