Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Consider different conditions for each ID in Power Query

Hi all,

 

I have a doubt regarding a transformation in Power Query. I´d like to consider different conditions for each ID, for example, only select those IDs that have (as Brand) A and C.1 or C.2

And I´d need to perform this in P. Query not Dax.

 

IDBrand
400A
400B
400C.1
400C.2
401A
401C.1
402B
402C.2

 

Thanks in advance

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

    Please have a try.

    Add a conditional column.

    Then filter the column.

     

    If I have misunderstood your meaning, please provide more details with your desired output.

     

    Best Regards

    Community Support Team _ Polly

     

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