Forum Discussion
Filter column based on another column
Hello All, I need some help to find out if it's possible to filter a column based on a column in the Power Query Editor in Power BI Desktop. I have a column called OrderQty and I need it to be le...
If you are comparing values in the same row, add a column and give it a value (e.g. 1) if one column is bigger than the other (and 0 if not).
Then you filter out the 1s or 0's (depending on your logic) using the dropdown from the column header