Compare Two Columns From Different Tables

[barim]

Hello,

I would like to compare Table1 Column1 with Table2 Column2. If Column1 value =Column2 value it should be printed "Match" if not "No Match". Both columns are formatted as text. I guess, this should be Custom Column and DAX formula.

 

[sandy666]

try Comparing Columns in Power Query

 

[sandy666]

or you can try this as a model to be expanded

[SIZE=1]// Table1
let
    Source1 = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Source2 = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    Compare = Table.AddColumn(Source2, "Compare", each List.Contains(Source1[type],[type])),
    ROC = Table.SelectColumns(Compare,{"Compare"})
in
    ROC[/SIZE]

but result is TRUE / FALSE