Forum Discussion
Removing Specific Rows from the Dataset
Hello, I need to remove specific, nonconsecutive rows within my dataset in Power BI. For example, I have 5 different locations (1-5) and 5 different products (A-E). I need to filter out Location...
Anonymous - Create a column that concatenates your two columns. You may have to do a type conversion for your numeric column,
Text.From([Location]) & [Product]
Then you can remove just the rows you want.
Add a custom column like this to get more specific
if [Location] = "Location 1" and [Product] = "Product B" then 1 else 0
Then you can just filter out the rows with 1 in the new column.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat