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

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
biwarrior93
Regular Visitor

Custom index assignment

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. 

3 REPLIES 3
biwarrior93
Regular Visitor

biwarrior93
Regular Visitor

Something like that below. I want the index to be presented this way. 

IMG_20230208_153432_720.jpg

Greg_Deckler
Community Champion
Community Champion

@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.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.