Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to 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.
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.
User | Count |
---|---|
10 | |
7 | |
5 | |
5 | |
4 |
User | Count |
---|---|
15 | |
14 | |
8 | |
6 | |
6 |