I'm trying to figure out how to select rows from a table based on two different criteria and OR the results. So far, it seems the way to is do one query, then a second query and append the first. This seems awkward, and I was hoping there was a way to put both criteria into one query?
The old data functions in Excel you would just put each criteria in its own row and the result would be OR'd, anything similar in Power Query?
The old data functions in Excel you would just put each criteria in its own row and the result would be OR'd, anything similar in Power Query?