Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Help on fuzzy matching

Hello!   Could someone assist me in matching names between two tables?   I have two tables: "Client Name" and "Employee Name." My goal is to create a new column in the "Client Name" table that id...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

    Below is my table1:

    Below is my table2:

    Then you can use fuzzy match:

    The final output is shown in the following figure:

    After filter:

    The following DAX might work for you:

    Column = IF('Table'[Table (2).Employee Name] = RELATED('Table (2)'[Employee Name]),"Empolyee",BLANK())

    Best Regards,

    Xianda Tang

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

Below is my table1:

Below is my table2:

Then you can use fuzzy match:

The final output is shown in the following figure:

After filter:

The following DAX might work for you:

Column = IF('Table'[Table (2).Employee Name] = RELATED('Table (2)'[Employee Name]),"Empolyee",BLANK())

Best Regards,

Xianda Tang

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