Counter on values

[Anonymous]

Hi all,

I'm rather new to Power BI and I would like some help with creating a counter. The first time a value occurs in a column, I would like to have value "1", the second time it occurs value "2", and so on.

I know how to do this in Excel but not in Query Editor. Hopefully someone can help me out.

Greetings.

[Anonymous]

@ChielFaber  Thank you very much

[ChielFaber · Accepted solution]

I think this blogpost by Reza Rad might help you get to your solutions:

https://radacad.com/create-row-number-for-each-group-in-power-bi-using-power-query

It uses an index with a group by function. The explanation is easily written and you can just follow the steps replacing the example columnames by the column names in your data.