Finding Duplicates

[houston39]

Hi Everyone,

Is there a way to filter out duplicates in this table?  Thank you in advance.

Sample:

[selimovd]

Hello @houston39 ,

there are ways to filter out duplicates. But please be a little bit more specific.

Do you want to filter out duplicates of VENDORID? Or duplicate rows, like VENDORID, DOCAMNT, Year, Month, Day are exactly the same?

How should the result look like?

As you are already using a table the duplicates are usually already summed up.

Best regards

Denis

[houston39]

Hi Denis,

Sorry about that.  Example - if the values are the same in the rows:

VendorID  DocAmt Day Month Year

00100        500.00    10  03         2021

00100        500.00    10  03         2021

Will display as

VendorID  DocAmt Day Month Year

00100        500.00    10  03         2021

I hope this helps. Thank you.

[Ashish_Mathur]

Hi,

To your visual, drag VendorID, Day, Month and Year to the visual.  Write this measure

=min(data[DocAmt])

[v-alq-msft · Accepted solution]

Hi, @houston39 

Based on your description, I created data to reproduce your scenario. It works properly. The pbix file is attached in the end.

Table:

Result:

Could you show us more details about the problem?

Best Regards

Allan