Power Query Grouping adding index at group level and expanding puzzle

Hello,
I wondered if someone might be able to explain or find of interest this;

when grouping 'All Rows' you can then expand a single group , and In this case I wanted to add an index to make a function,
that's fine and not anything to do with this.

But i thought I'd add the index to each grouping in the formula bar before expanding the single group,

Please Login or Register  to view this content.

,

This what's puzzling , now when a single 'table' of the 'all rows' is expanded the entire table is expanded not jus the selected one.

I've attached a small workbook with two examples I've tried to label each step descriptively, it's not a huge problem, just curious.


Richard.

Administrative Note:

We would very much like to help you with your query, however you need to include code tags around your code. See your previoius thread for further instructions on how (and how NOT) to do this.

https://www.excelforum.com/office-36...ing-today.html

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Thanks - now you know.

Your issue is that you are using "Source" as basis of adding Index. You should rather use current table context. (i.e. use "_")
Ex:

Please Login or Register  to view this content.

Edit: Added i.e. portion

Edit2: If you wanted index added to all rows level. You must add index prior to grouping operation.

Please Login or Register  to view this content.

No, the question is why when expanding, does it reuturn the entire table

I know. When you use "Source" as reference table when you add index. You are not actually segregating to grouped context. Each grouped table will have entire "Source" as your group context.
Hence, you get entire table back when you expand.

Compare your code with mine. I used "_" in each context, which adds index within group. Not to entire table context.

Try running query with the change. You should only see 7 rows for "c" with index 1 to 7 assigned.

Latter edit. Will return 7 rows for "c" with index 14 to 20.

You are welcome and thanks for the rep