Forum Discussion

Lily_DS's avatar
Lily_DS
Frequent Visitor
4 years ago
Solved

add new column ( true false) based on another table

Hello    I have 2 tables(A , B) , I need to add [true , false] column to tableA if  row in TableA same in TableB  return True     I tried this , but i got errors     = List.Contains(TableB...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    If you are trying to get the result in Power Query Editor, please check the below picture and the attached pbix file.

     

    = Table.AddColumn(Source, "Custom", each if List.Contains(TableB[B], [A]) then true else false)

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

Hi,

If you are trying to get the result in Power Query Editor, please check the below picture and the attached pbix file.

 

= Table.AddColumn(Source, "Custom", each if List.Contains(TableB[B], [A]) then true else false)