Forum Discussion
Elina_Mirin
Advocate II
Advocate IIDoes not Contain filter in Power Query removes NULL values
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 k...
watch my video and you will know how to solve the problem
https://1drv.ms/v/s!AiUZ0Ws7G26RhlWZ9AMUAAFdgqmG?e=venO0dHi, you can wirte like this:
Table.SelectRows(#"Измененный тип", each not Text.Contains([data] , "yahoo") or [data]=null)
Elina_MirinAdvocate II
Advocate IIAhmedx 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
Super User
Super UserHi, you can wirte like this:
Table.SelectRows(#"Измененный тип", each not Text.Contains([data] , "yahoo") or [data]=null)