Create Index Column By Group in Power Query

This video shows how to create an index column for each category in your table. Within each category the number then starts from 1 and increases sequentially up to the number of items in your category.

Master Functions and Syntax in M

ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.

SUBSCRIBE TO MY CHANNEL

LET'S CONNECT:

Thank you for your support!

00:00 Introduction
00:26 Add Regular Index
01:02 Method 1: Separate Column
03:15 Method 2: Adjust Group By - Lose Data Type
07:28 Method 3: Adjust Group By - Define Data Type

#index #powerquery #bigorilla

[ДенисДементьев-то]

Dear BI Gorilla, your way of explanation is extremely clear and understandable. Thank you very much for video.

[FRANKWHITE]

To honor this film I've called one step of my query "bi gorilla" ❤

[ericrobbins]

OMG, THIS, THIS, THIS...I needed THIS! Thank you. Subscribed!

[viniscera-]

Thank you from Brazil! This solution solved my problem

[alexrosen]

Very useful tutorial. Many use cases for example to create unique index numbers for rows in different segments.

[fajnefajne]

I love this comprehensive explanation. Thank you.
I feel like in the supermarket. I have a choice and I can pick up the solution I like 😊

[InventarioGintracom]

I was searching this, and i did not find any video who can explain it in spanish, thank you!

[raulparra]

Gracias por compartir. Como siempre muy util este tutorial. Saludos desde Bogota - Colombia

[williamarthur]

I enjoyed the last version as it brought up the index not showing in expand,
I've always just removed everything after each and
// Table.AddIndexColumn( _, "Index", 1, 1, Int64.Type) }} ) //
which doesn't cause the problem of not showing index , it's not something I'd considered and it's good to be aware of these things. I enjoy your relaxed manner very much.

[NSLABTUTORIAIS]

Thank you very much. It was what I was looking for.... Muito, muito

[MaydayAggro]

Took me forever to ask a question of Google the right way to get this video as an answer. I need to reconcile accounts with thousands of transactions per month and sometimes dozens of repeated amounts per day. Creating an index for each amount makes the job much easier, especially since my two queries do not have any like columns other than amount.

[vaigundhansridhar]

this was amazing! Just what was needed while solving a tough use case. Thank you :)

[dmederos]

2:35am and can't keep watching your videos🤣
This one is super handy, I feel I'm getting closer to the solution I want to implement!

[FabianH-zsgo]

Great Video, exactly what I was looking for! Thanks.

[matheusgameiro]

Useful bro!

A manager just got mass clients transfer to his wallet, then asked me for help to get an overview about his "new wallet" what they have in pipeline, lost/cancel history and the active contracts.

I needed to create a column with the most recent 3 contacts from the account, first i ordered desc, then used index and finally filtered index = 0 or 1 or 2 (top 3)

;)

tks

[ThamerAffara]

Thank you for this wonderful easy to follow!

[pieterlinden]

Oh, that's super handy! It lets you do the equivalent of ROW_NUMBER() OVER (PARTITION BY...) in T-SQL, but without having to import your data into SQL Server first! Then you can do things like TOPN, but at the data source level.

[minadev]

I am an accounting person and wanted to learn Power BI, should I start working on M language too?

[julliettecarignan]

I'm curious what would be some use cases why there'd be value in having separate index sequences for the various groups? This is useful, thank you, just trying to figure out what requirement this helps us deliver (even if an intermediate one).

[gscosandygoodwin]

@BiGorilla - This is great, but it defines the index based on Column 1 and then Column 2. However, how can the Index be added based on Column 1 and Column 3 without reordering the columns. Column 1 (Color Group) and Column 3 (SalesAmount) would be a more logical indexing in your data set.