Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Delete multiple rows based on values in 2 columns

Hi all, I'm new to PowerBI and no experience of DAX (to speak of). I need to reduce the nr of rows in a report, based on the values of 2 columns. For the same Request Nr, i have multiple rows wi...
Need Help
Tips and Tricks
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi Anonymous ,

     

    In Power Query, multi-select (Ctrl+click) your [Request ID] and [All Return Reasons] columns then, on the Home tab, go to Remove Rows > Remove Duplicates.

     

    Pete

BA_Pete's avatar
BA_Pete
Super User
4 years ago

Hi Anonymous ,

 

In Power Query, multi-select (Ctrl+click) your [Request ID] and [All Return Reasons] columns then, on the Home tab, go to Remove Rows > Remove Duplicates.

 

Pete

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    thanks BA_Pete .
    Does this also works for multiple Request Nrs with the same list of return reasons?
    Thanks

    • BA_Pete's avatar
      BA_Pete
      Super User
      4 years ago

       

      By selecting the [Request Nr] column along with the [All Return Reasons] column, you're essentially creating an instruction that says:

      "Remove any duplicated combinations (imagine concatenating these two fields then removing duplicates from the concatenated list) of [Request Nr] and [All Return Reasons]" so yes, this will work to remove duplicates within each [Request Nr] group separately.

       

      If you only selected [All Return Reasons] before removing duplicates, it would just give you a unique list of this field, and would remove instances where the return reason was present again within a different Request Number.

       

      Pete