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
v-xuding-msft's avatar
v-xuding-msft
Community Support
7 years ago

Hi nleuck ,

Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from here.

 

Best Regards,

Xue

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

nleuck's avatar
nleuck
Post Patron
7 years ago

v-xuding-msft 

 

No. None of these helped. Thanks anyways.

  • 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?