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.
Hi all,
I bumped into a puzzle that I do not understand...
In power query I have two columns - State (that gives values Cancel, Sales, etc..) and Confirmation Date (gives null or specific date).
I want to filter all rows that contain at the same time Cancel and null. I tried to use Filter Rows - advanced filter and .... it doesnt work. It filters all Cancel and all nulls ... I cant see why... I am not sure about the code, but the logic in the user interface function should clearly work this way, but it doesnt .... or am I missing something?
I managed to find another way to filter the rows, by adding new column and then filtering by it... but I would like to do it in one easy step... not three. Can somebody tell me what is going on?
= Table.SelectRows(#"Added Custom", each [public.sale_order.confirmation_date] <> null and [state] <> "cancel")
Solved! Go to Solution.
Please try this instead
= Table.SelectRows(#"Added Custom", each not ([public.sale_order.confirmation_date] = null and [state] = "cancel"))
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Please try this instead
= Table.SelectRows(#"Added Custom", each not ([public.sale_order.confirmation_date] = null and [state] = "cancel"))
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
You are the boss, sir 🙂
However, do you think, that the user interface window just doesn't function properly (giving incorrect code), or am I doing something wrong?
Thanks
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 |
---|---|
101 | |
49 | |
19 | |
12 | |
11 |