Matching column in Power Query

[Anonymous]

Hello communities ! 

I want to do matching different from differents tables (let say Table1 and Table2),

then I want to take column "LienPhoto" from table 2, and put it in column "Photo" in Table1 

Is this possible through a power query or DAX calculation?

Thank you so much!

Best Regards,

[Anonymous · Accepted solution]

Hi @Anonymous ,

About matching columns by dax, please kindly refer to this article.

The main measure is like

  [Is this company a metals company] =

  =IF(
      SUMX(MatchList,
           FIND(
                UPPER(MatchList[Keyword]),
                UPPER(Companies[Company])
                ,,0
               )
          ) > 0,
      “YES!”,
      “Probably Not”
     )

About matching columns in Power Query, you can refer to MATCH between 2 tables. Mainly rely on the following two operations.

Another solution using Query Editor.

1. Left Outer Join

2. Conditional Column.

See the attached screenshots.

LEFT OUTER JOIN

EXPAND COLUMN

CONDITIONAL COLUMN

FINAL OUTPUT

Reference: Matching between 2 tables

Best Regards,

Stephen Tao

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

[AlB]

Hi @Anonymous 

Not clear. Show some sample data for the input as well as the expected output and base your explanation on that.

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.