Conditional Column in Query using fuzzy matching?

[SevsBo]

I'm trying to create a conditional column that would identify a fuzzy match for a result.

So let's say I want to find an entry that has "United States of America" in it. In Excel I can write a function with the search term "United*America" and that would find it, but is there an equivalent when creating a Conditional Column in Query mode in Power BI for it?

[v-zhengdxu-msft · Accepted solution]

Hi @SevsBo 

Thanks for the reply from @ryan_mayu , please allow me to provide another insight:

Please try the Text filter which support fuzzy match:

Text Filter (microsoft.com)

You can search it by click the (...) in visualizations pane and select Get more visuals:

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ryan_mayu]

we can do fuzzy  matching in powerbi, but it's automatic

https://learn.microsoft.com/en-us/power-query/merge-queries-overview#fuzzy-matching?wt.mc_id=DP-MVP-...

that's sounds different from your scenario. pls provide some sample data and expected output