Create Index Column By Group in Power Query

Great! That's super helpful. Thanks!

In my case, I'm using a calculated table, but the issue is that calculated tables don't show up in Power Query.

How can we do multiply two columns from different tables using custom function in power query??

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

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

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

Thank you so much! Exactly what I've been looking for 😍

I stopped using the expand option long long time ago, its faster to convert the Column with Table objects to a list and then using Table.combine fonction on top of that list result of tables.

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

Yours videos are great. Thanks

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

Excellent! Thanks man!

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!

I like the first method

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.

Thank you Bro

What if we want to reset the index end of the month. I have IT helpdesk data and like to calculate the avg number of tickets per month and year

I reckon number 3 is my favourite one

Nice thank you

I always have to sort rows in columns after some steps, sometimes several times to get exactly what i want.

Oh, a bit late i've saw this video, cause i forgot a case i wanted to apply this! :(
So, i need to remember this method at least for later, may be i'll remember my case. :)
THANKS, Rick!

Awesome 👌

I'll Look forward to it.

Very useful 👍

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

Re accumulate , this is slightly different to what I found online and cuts out some of the steps, add index to source, ; then insert step;
Table.AddColumn(#"Added Index", "RTC ", each List.Accumulate (
#"Added Index" [Units], {0} , (Step, Current ) =>

Step & { List.Last(Step) + Current } ) {[Index]})

I've never really got to the bottom of the ampersand, but then I could never have crated the List.Generate Febenoci sequence either, another really good video.

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.

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