Does not Contain filter in Power Query removes NULL values

[Elina_Mirin]

Hello! Does anybody know why 'Does Not Contain' filter in Power Query removes also null values, not only the value specified?

E.G.: I want to exclude the emails that contain "yahoo", but I want to keep the null values.

= Table.SelectRows(#"Filtered Rows", each not Text.Contains([Email], "yahoo"))

[Ahmedx · Accepted solution]

watch my video and you will know how to solve the problem

https://1drv.ms/v/s!AiUZ0Ws7G26RhlWZ9AMUAAFdgqmG?e=venO0d

[Elina_Mirin]

@Ahmedx thank you for this video! It's working now. Do you know why Power Query does this with null values? I can't find a logic explanation in any documentation provided.

[Ahmedx · Accepted solution]

Hi, you can wirte like this:

Table.SelectRows(#"Измененный тип", each not Text.Contains([data] , "yahoo") or [data]=null)

[Ahmedx · Accepted solution]

watch my video and you will know how to solve the problem

https://1drv.ms/v/s!AiUZ0Ws7G26RhlWZ9AMUAAFdgqmG?e=venO0d