We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register 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.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 6 | |
| 4 | |
| 3 | |
| 2 | |
| 2 |
| User | Count |
|---|---|
| 11 | |
| 10 | |
| 7 | |
| 7 | |
| 6 |