Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
houston39
Helper I
Helper I

Finding Duplicates

Hi Everyone,

 

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

 

Sample:

 

houston39_1-1615838135378.png

 

1 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:

a1.png

 

Result:

a2.png

 

 

Could you show us more details about the problem?

 

Best Regards

Allan

 

 

View solution in original post

4 REPLIES 4
selimovd
Super User
Super User

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

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.

 

 

Hi,

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

=min(data[DocAmt])


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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:

a1.png

 

Result:

a2.png

 

 

Could you show us more details about the problem?

 

Best Regards

Allan

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.