Forum Discussion

haliddelkic's avatar
haliddelkic
Frequent Visitor
4 years ago
Solved

Remove multiple rows with matching ID, based on a variable value in another column

Power BI newbie here looking for some help.  In my scenario, I have a dataset where the same customer may appear in multiple rows. In each row, the customer's reference ID is the same but across ot...
Need Help
v-kelly-msft's avatar
v-kelly-msft
Community Support
4 years ago

Hi  haliddelkic ,

 

Go to query editor ,then create a  custom column as below:

=Text.Contains([Variable Value Column],"lue 3")

Then create a new table to remove the rows where the result is true:(Or you could filter out the rows where the result is true in the oringinal table)

= Table.SelectRows(#"Table",each [Custom]=false)

And you will see:

For the related .pbix file,pls see attached.

 

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

  • haliddelkic's avatar
    haliddelkic
    Frequent Visitor
    4 years ago

    Thanks for your help, Kelly.

     

    However, I was looking to go a step further and remove all rows where the unique reference number is the same as the row where result is TRUE. 

     

    So in this scenario, we've identified a single row and tagged it as TRUE using a custom column. We know that person is Fred Jones and his unique reference number is 1234.

    Now I want to locate and remove all rows where reference # is 1234.

     

    Hopefully, that makes more sense.
    Halid