Solved: Counter on values

Anonymous · ‎03-30-2023

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.

ChielFaber · ‎03-30-2023

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.

[Tip] Keep CALM and DAX on.
[Solved?] Hit “Accept as Solution” and leave a Kudos.
[About] Chiel | SuperUser (2023–2) |

View solution in original post

Anonymous · ‎03-30-2023

@ChielFaber Thank you very much

ChielFaber · ‎03-30-2023

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.

[Tip] Keep CALM and DAX on.
[Solved?] Hit “Accept as Solution” and leave a Kudos.
[About] Chiel | SuperUser (2023–2) |