Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    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.