Using M to Check If a Value Exists in Another Table (Power Bi)

Question

I have 2 tables,

Table 1
Column1
Alex
Barry
Chris

Column1
Name
Miranda
Fanta
Barry

I want to remove any rows from Table 1 that is present in Table 2 in the query editor

To do this, I need to create a column called as IsPresent in Table1.

Column1  IsPresent
Alex       No
Barry      Yes
Chris      No

How can I create this IsPresent column using M? Is it even possible, if not why ?

Accepted Answer

You can certainly write a custom column for this

if List.Contains(Column1[Name], [Column1]) then "Yes" else "No"

However, if your goal is just "to remove any rows from Table 1 that is present in Table 2" then you can do a left anti join instead of defining a custom column and filtering.

Using M to Check If a Value Exists in Another Table (Power Bi)

1 Answer

Must Read

Your Answer

Elena Rostova

Using M to Check If a Value Exists in Another Table (Power Bi)

1 Answer

Must Read

Your Answer

Sign up or log in

Post as a guest

Elena Rostova