garyj
09-06-2023, 11:48 PM
Hello to all in Power Query world...
I developed a table, selected Data/ "Queries and Connections" and then "From Table/Range". I want to query the table by "null" values in either of 2 columns. In other words if either field has a null value in one record, I want that record to show. I estimate it to be something like this...
[CODE]= Table.SelectRows(#"Changed Type", each ([Field1] = null or [Field2] = null))
Then I close and load. I take that query and move it into the form where I want it to show. In the first field is the individual ID. The user selects the ID they want to view and it now needs to refresh with all records for that individual that have either Field1 or Field2 as null. But it is also loading records from other individuals that are null. See picture attached. (The first queries skipped row 1, which makes sense, no nulls. It for some reason ignored row 2 - not sure why. It then took row 3 which means the either or is working at least for that field. It then took row 4 which could be for the ID or for the nulls or both?
Any idea how to fix it? I need to have the ID selection made by user, and the other to always be there.
Thanks
31030
Gary
I developed a table, selected Data/ "Queries and Connections" and then "From Table/Range". I want to query the table by "null" values in either of 2 columns. In other words if either field has a null value in one record, I want that record to show. I estimate it to be something like this...
[CODE]= Table.SelectRows(#"Changed Type", each ([Field1] = null or [Field2] = null))
Then I close and load. I take that query and move it into the form where I want it to show. In the first field is the individual ID. The user selects the ID they want to view and it now needs to refresh with all records for that individual that have either Field1 or Field2 as null. But it is also loading records from other individuals that are null. See picture attached. (The first queries skipped row 1, which makes sense, no nulls. It for some reason ignored row 2 - not sure why. It then took row 3 which means the either or is working at least for that field. It then took row 4 which could be for the ID or for the nulls or both?
Any idea how to fix it? I need to have the ID selection made by user, and the other to always be there.
Thanks
31030
Gary