Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Level up your Power BI skills this month - build one visual each week and tell better stories with data! Get started

Reply
lherna3
New Member

Power query formula needed

 I need to compare multiple rows for matches in the same column and add a suffix when the rows have the same information. 

In the figure below you can find my column "Nom", it can be repeated several times and I woudl like to add suffix "A", "B", "C", etc. for the same "Nom" number and leave it as it is if it doesn't repeat. 

 

I appreciate your help, I've been trying for several hours 

 

lherna3_0-1699658151145.png

 

lherna3_1-1699658401733.png

 

1 ACCEPTED SOLUTION

and this is if you need the alphabet sequence A, B, C...

View solution in original post

6 REPLIES 6
Ahmedx
Super User
Super User

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Screenshot_7.png

I changed the M code, try again

and this is if you need the alphabet sequence A, B, C...

Thank you very much! That is exactly what I was looking for. 


If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Ashish_Mathur
Super User
Super User

Hi,

Why does the third entry of each id nt have a - A?


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
April Power BI Update Carousel

Power BI Monthly Update - April 2026

Check out the April 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.