This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
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.
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.