Delete multiple rows based on values in 2 columns

[Anonymous]

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 with the same value in the "All Return Reasons" column.

How do i write a code to only have 1 row for each of the values in the "All Return Reasons" column?

See below example.

Thank you

[BA_Pete · Accepted solution]

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]

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

[BA_Pete]

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