Forum Discussion

nleuck's avatar
nleuck
Post Patron
7 years ago

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...
Need Help
HotChilli's avatar
HotChilli
Community Champion
7 years ago

Can you provide a data sample, please?

It's not clear to us where the columns you are asking about are located.

Different tables or the same table?

I'm sure we can help.

nleuck's avatar
nleuck
Post Patron
7 years ago

HotChilli 

 

The columns are in two different tables.

  • HotChilli's avatar
    HotChilli
    Community Champion
    7 years ago

    OK, thanks.  Is there a data sample?