Forum Discussion
New Table with OR Logic from Multiple Columns
I solved my own question after playing around with it for awhile:
In PowerQuery, I created the new table as a copy of the old table. Then, I filtered the column Major 1 to =A to generate the code for the step as follows:
= Table.SelectRows(#"Added Conditional Column", each ([Major 1] = "A"))
Then in the Advanced Editor, changed it to the following:
= Table.SelectRows(#"Added Conditional Column", each [Major 1] = "A" or [Major 2] = "A")
which left me with a table of the rows I needed.
I solved my own question after playing around with it for awhile:
In PowerQuery, I created the new table as a copy of the old table. Then, I filtered the column Major 1 to =A to generate the code for the step as follows:
= Table.SelectRows(#"Added Conditional Column", each ([Major 1] = "A"))
Then in the Advanced Editor, changed it to the following:
= Table.SelectRows(#"Added Conditional Column", each [Major 1] = "A" or [Major 2] = "A")
which left me with a table of the rows I needed.