Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
I have a table with four columns : ID, Email, Phone 1 and Phone 2 columns. The Ids are unique for each entry. I need to assign a unique index to every entry, but the entries with same information need to have the same index. Same information can be found if an email is the same, a phone 1 or phone 2 are the same or a phone 2 is same with a phone 1 and the other way around. Indices will be also assigned to the entries that do not have connections. I need to perform this in Power Query.
Something like that below. I want the index to be presented this way.
@biwarrior93 Can you provide sample data? The basic process I see for this would be to essentially get this in a form where you could do a "Group By", assign an Index and then expand it back out.
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 16 | |
| 14 | |
| 9 | |
| 8 | |
| 7 |