Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello
I have linked two datasources where I need to compare address fields for a match.
I'm having trouble comparing the address columns for a match as the string in each column is not a direct match.
An example of what I'm trying to achive is in the table below. Column A and B have the address fields, Column C would output if there is a match or not. I've been playing around with Conditional Columns and searching for "text.contains", but I can't figure out how to do this, or if this is the best way to achive the outcome.
My thinking is for the first row, search for text "Plum" in Column A and Column B, and then output to Column C if there is a Match.
Any help or pointers would be appreciated. It's probably a simple solution but I haven't been able to figure it out!
Column A | Column B | Column C |
Plum St | 123, Plum Steet, Some City | Match |
Cherry Ln | 478, Cherry Lane, Some City | Match |
Stuart Ave | 1, Stuart Avenue, Some City | Match |
Cherry Ln | 123, Plum Steet, Some City | No Match |
Solved! Go to Solution.
This could be a starting point:
I've highlighted the problem area: "Ln" doesn't match with "Lane" so you have to decide how to deal with this: Either create a list of abbreviations that will be deleted in ColumnA before the match, cut off the last word from ColumnA or other strategies.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
This could be a starting point:
I've highlighted the problem area: "Ln" doesn't match with "Lane" so you have to decide how to deal with this: Either create a list of abbreviations that will be deleted in ColumnA before the match, cut off the last word from ColumnA or other strategies.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |