Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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"))
Solved! Go to Solution.
watch my video and you will know how to solve the problem
https://1drv.ms/v/s!AiUZ0Ws7G26RhlWZ9AMUAAFdgqmG?e=venO0d
Hi, you can wirte like this:
Table.SelectRows(#"Измененный тип", each not Text.Contains([data] , "yahoo") or [data]=null)
@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.
Hi, you can wirte like this:
Table.SelectRows(#"Измененный тип", each not Text.Contains([data] , "yahoo") or [data]=null)
watch my video and you will know how to solve the problem
https://1drv.ms/v/s!AiUZ0Ws7G26RhlWZ9AMUAAFdgqmG?e=venO0d
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |