Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Difference between Excel fuzzy vs Power BI fuzzy

Hi Everyone,

 

I know Fuzzy match is available on PowerBI now and I am wondering if this is a better logic(higher accuracy) of Fuzzy than Excel? I used to do it in Excel and if Power BI is better, I would like to switch.

 

Thanks in advance,

 

Wilson 

  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous,

     

    AFAIK, current power bi not support direct use specific match symbol in filter.

    You can take a look at following blog to know how to use left, right functions with search function to achieve fuzzy match.

    From SQL to DAX: String Comparison

     

    Regards,

    Xiaoxin Sheng

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous,

     

    AFAIK, current power bi not support direct use specific match symbol in filter.

    You can take a look at following blog to know how to use left, right functions with search function to achieve fuzzy match.

    From SQL to DAX: String Comparison

     

    Regards,

    Xiaoxin Sheng