Forum Discussion
How to extract continuous string set from a column with multiple criteria
Anonymous - OK, I updated this with a Client Name output version and Project output version in 2 additional columns. I checked the matches, don't see anything obviously amiss. Solved?
PBIX is attached.
Greg_DecklerThanks for your explanation. The Fuzzy match aint working as expected. For example: Client_name is "BARCLAYS CAPITAL". This client name is getting matched with Project_name - "TriState Capital" instead of Barclays (ABC) with 0.24 threshold (the least I could set for a maximum output).
With threshold of 1 , BARCLAYS CAPITAL has no matches and returns NULL.
Due to the above, I really doubt if the results with Fuzzy matching are accurate for my datasets. I do not want a wrong project to be mapped to a client name.
Let me figure out something, if nothing works out then I should probably write to the management to tweak the data source to match with the Client Name without the (ABC) or apostrophe 🙂
Thanks again for your time.
Anonymous - Yeah, even with what I laid out if it was even possible in DAX, you would end up with the same exact problem. You will run into situations where there isn't a firm way to decide if "Barclays Capital" better matchines "Barclay's Investments" or "Tristate Capital" for instance. How do you decide? In that example, both would match 7 consequetive letters. Technically " Capital" is 8 so it would probably win. That's just an example of what you run into with fuzzy matching scenarios.