No results on ETL-filtering

[PZUDGW]

I like to filter a column. The text in the column "NAME" must contain either "kale" of "iah". I get no results on the next formula:

= Table.SelectRows(MRPMCCONTRACTLINES1, each Text.Contains([NAME], "iah") or Text.Contains([NAME], "kale"))

What goes wrong?

Gr. Patrick

[v-eachen-msft]

Hi @PZUDGW ,

I created a sample file and test it with your m query. The result is correct.

You could check if "MRPMCCONTRACTLINES1" step has correct values you need and if your each two conditions will return correct results. 

[HotChilli]

Syntax looks OK.

Did you write the code yourself or use the Text Filter on the column dropdown? (Using the Text filter should guarantee correct column names and syntax)

I suggest testing with only 1 condition and see if that works first, then introduce the OR with the other clause.