Create an Index Column for Subgroups in Power Query

- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

- - - - Blog - - - -

[imronnesia]

Love the way you explain everything. You always make some complex things become a simpe thing with simple and easy explanation.

[SaniGarba]

One word, "Ëxcellent". I've seen a few approaches to this problem, yours is the most ingenious by its simplicity. Thanks.

[venkateshpandian]

Very useful trick. I always admire, your videos are in a simple language and easy to understand and digest. Thanks for sharing your knowledge.

[thamirlnaachiyaar]

I greatly appreciate it, it helped me to reconcile accounts with many transactions having the same value. I was struggling to work it out to eliminate the duplicate. 🙏🙏 as the query picking up all rows with the same value instead of one.

[FutureFaz]

I used this to create dropdowns for a boatload of data options based on the first column. Thank you!

[Kurt]

Exactly what I needed, would like twice if possible!

[kiadyandrianantoandro]

Daim man you just saved me millions of hour I cannot expresse how thankful I am !

[juansepowerplatform]

Thanks for your videos, best resource to really grasp M code.

[jasonswami]

Clear and concise. An excellent tutorial🙏🙏🙏

[paulkogels]

Very helpful. Very clear explanation. Thank you.

[sjh]

Thx for this video, easy to understand. I do have another approach though (may work better with 'smaller' datasets. I use a simple formula. In cell L3: COUNTIF($J$3:J3, J3). Copy down. Cell L4 should read COUNTIF($J$3:J4, J4) and so on.

[Ratnakumarwrites]

Hooray Man... U r there for my problems & I stuck.

[sunnygala]

Thanks Chandeep! Really love your teaching approach. Cheers

[algawzy]

You are perfect I spend many times to reach the solution 👌

[gennarocimmino]

kudos for the clarity!

Suppose I need to pick/select the first "n" ranked people in each subgroup (not the first two, not last three, etc.).

Let's say that I have a number of gifts/prizes to provide to each subgroup: to the first subgroup I will award two gifts, to the second subgroup I will award three gifts, to the third subgroup one gift, etc.

The number of gifts/prizes to be assigned to each subgroup is a second available table.
So, after creating the subgroup index, I am only interested in seeing/selecting from that particular subgroup a number of records equal to the number of available gifts/prizes from the other table.

Can this be done?

Namaste!

[tofuboyvn]

great video, you helped me solving my issue.
but i have a question. After grouping and attribute the index for each table, can we export the table into many excelsheet for each group ? and how ?

[aas]

dis was to build gradient fill curved area chart in power bi

[rupalmukhi]

Nice video. How to compare the values for each subgroup at Index 1and 2 ?

[ashithachillara]

If we have multiple dimensions (Category, Sub-category, items) then how can we give index for category column.

[Alan.DL]

Awesome resource. Quick question though, is there any reason why NOT to use the 2 arrows on the header to expand the table instead of writing the code as you did? The end result is the same but maybe I am missing something here.

Cheers!