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.
what is the source of the table in M?
The original table is an Excel Workbook, so:
= Excel.Workbook(File.Contents("[File Path]"), null, true)
Unpivoting would create a ton of excess columns as there are quite a few different values, so I was also hoping to avoid that.