Forum Discussion

sribmc's avatar
sribmc
Helper I
1 year ago
Solved

Need help in custom column

I have 2 tables which contains states data.I want to create new custom column at table 2 to show matched values from table1   Table 1 Table 2 Andhrapradesh Telangana(456) Telangana Punj...
Need Help
  • techies's avatar
    techies
    1 year ago

    Hi sribmc please check this

    if List.Contains(#"A"[table A], [table b]) then [table b] else null

techies's avatar
techies
Super User
1 year ago

Hi sribmc please check this

if List.Contains(#"A"[table A], [table b]) then [table b] else null