Forum Discussion

spage's avatar
spage
Regular Visitor
3 years ago

Is it possible to return a specific text string if the Text in column A matches text in column B?

Hello,

 I have included a snapshot of two columns I added to a visual in Power BI.  Is there a way to say If the Ship to Name is a Fuzzy Match to the Customer Name, return the word "stock", if not "Direct".  These columns are from two different tables.

 

Need Help

1 Reply

  • PhilipTreacy's avatar
    PhilipTreacy
    Icon for Super User rankSuper User
    3 years ago

    Hi spage 

     

    You can do fuzzy matching in Power Query which might give you what you want.  Depends on how fuzzy the match has to be.

     

    This approach will give you a new table with the above 2 columns plus the 3rd fuzzy matched column.

     

    Regards

     

    Phil