Forum Discussion

vojtechsima's avatar
vojtechsima
Icon for Super User rankSuper User
5 years ago
Solved

Power Query M - If Row is equal to another row in different table

Hello,

I have these two tables:
TABLE1

TABLE2

I need to add a custom column to TABLE 1 that would check if KEY in TABLE 1 also appears in TABLE 2 then it would do something.

The name structure is the same, I need to do it in Power Query M.

I thought something like this would do that trick, but it seems I can't properly reference the other table's column:

if [Key] = (#"Backlog_Linked Issues"[Key]) then "Incident" else "Proactive"

I know it's a bit silly, but can you please help me with this IF Statement?

 

  • Put something like this in the if:

    List.Contains(Table2[Key], [Key])

1 Reply

  • HotChilli's avatar
    HotChilli
    Icon for Community Champion rankCommunity Champion

    Put something like this in the if:

    List.Contains(Table2[Key], [Key])