Show only 1 of a number of duplicate values

[Tob_P]

Hi

I'm looking to suppress these duplicate values. I need to be able to see all the Quote No's, their corresponding branch, contacts, customer & project names but just see the value on one row. To further add to this, and this may help..

Quote No/Type/Date/Contact/Project Name - Table 1

Branch - Table 2

Customer Name - Table 3

Value - Table 4

Thanks in advance

[Anonymous]

Hi @Tob_P I'm having a similar problem with my data. Did you ever solve this issue and can provide some insight?

[Tob_P]

I think I ended up dropping what I needed in this example, but if I were to tackle it now I probably would have used the RELATED function in Table 4, to bring in the Quote No (I'm pretty sure my existing relationship between Tables 1 & 4 would have required this), and create a calculated column.

[Tob_P]

Wondering whether anyone has any insight on this. Not an issue with my relationships.

Have tried a couple of things - SUMMARIZE function and creating a calculated column to CONCATENATE Project Name & Quote Number to create a unique ID and FILTER on that but with no success.

Trawling through the forum here but can't find a case study that fits the profile of this queston.

Thanks again in advance.

[Tob_P]

Hi @stevedep Unfortunately that's not an option for me as I believe that it would wreck the outputs in the rest of the report.

[stevedep]

Hi,

What is the unique identifier of the record?

[Tob_P]

In this case I would want to go with the Project Name - it will only ever have one value in it but will have multiple quotes

[stevedep]

Something with Ranking, and only showing the first value?

[stevedep]

Hi,

In Power Query you can remove duplicates.