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...
I ended up just doing the work in the Text of my query where I get the data source. It ended up being easier that way.
HotChilli your idea would have worked if the two columns were in the same table when I pulled the data in. Thanks for your response.
v-xuding-msft your idea would have worked as well except for once you merge queries the data because Mixed and I need it to be Direct Query, that way I don't have to manaul refresh the data. Thanks for your response.