Forum Discussion
Ranking
Hello, I finally found the solution here. This is exactly what I was looking for. But thank you for your help trying very quickly.
https://radacad.com/create-row-number-for-each-group-in-power-bi-using-power-query
Hi, dmatliak
Please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.
https://www.dropbox.com/s/19rqx3in7aqn86u/dmat.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
Hi Jihwan_Kim,
thank you for quick reply. But this is not what I am looking for. What I need as an output is this (see. the screenshot). For each customer I want all contacts to be showed but with rank 1,2,3 and so on, depending on how many contacts are for each client.
Thank you for help.
Dusan
Hi, dmatliak
Thank you for your feedback.
Sorry that I cannot create the relevant sample pbix file.
Please share your sample pbix file's link here in order to possibly not create any misunderstanding.
Thanks.
Hello, here is the link. I just uploaded new table to your template. My wishful state ist to have new column having numbers 1,2,3 for each row within the customer ID (For example C01 will have numbers 1-5 because he has 5 different contacts).