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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

How to remove duplicates in table chart

Hi Community,

 

Here i shared my table chart.. here i am getting duplicate Item descriptions because their id's are different. now what i want is if same item description is present in multiple times i want to show end date presented item description. i am not able to get how to achieve this... Some of item descriptions doesn't have end date at that time i want to show latest start date item description. whenever end date will come it will show start and end date presented item description

 

Please help me out from this

 

Capture.JPG

 

Thank you in advance

B V S S

11 REPLIES 11
Anonymous
Not applicable

Hello @Anonymous 

 

Create an Calculated Column with the below DAX

 

Column = IF( CALCULATE(  COUNTROWS(Table3),  ALLEXCEPT(Table3,Table3[Description]))>1,
                         IF(ISBLANK(Table3[EndDate]),  "No",  "Yes"),
                     "Yes")
 
And drop this field in the Visual level filter  and select "Yes"
 
VisualFilter.JPG
 
Hit Like if this helps you to resolve your issue
Nandri
Anonymous
Not applicable

Hi @Anonymous ,

 

Thank you for your response.. But I have data for Blank End dates also See below image. if two duplicate name comes at that i want to take that criteria otherwise i want to show all if end date is blank also

 

Capture.JPG

 

Thank you in advance

 

Regards,

B V S S

Anonymous
Not applicable

@Anonymous 

 

Have you try the 'Remove Duplicates' option from 'Query Editor' ?

 

RemoveDup.jpg

 

Try this and let me know 

 

Nandri

Anonymous
Not applicable

Hi @Anonymous,

 

We can't remove like that because those duplicate names id's are different

Anonymous
Not applicable

@Anonymous 

 

Try with Summarize table DAX function as like below

 

SUMMARIZE( Table3,Table3[Description],
                        "StartDate", MAX(Table3[StartDate]),
                        "EndDate", MAX(Table3[EndDate]),
                         "Amount", MAX(Table3[Amount]))
 
And change the Date Format for the date fields in the above created table
 
Hope this will helps you, waiting for your feedback 🙂
 
Nandri
Anonymous
Not applicable

Hi @Anonymous,

 

I tried i am getting this error.. i am not understanding what is my mistake.. and my dates are in mm/dd/yyyy format

Capture.JPG

 

Thank you in advance... Waiting for your more suggestionsSmiley Tongue

Anonymous
Not applicable

@Anonymous 

 

Can you please share either the source file or PBIX file ? Let me try to fix that and revert back. 🙂

amitchandak
Super User
Super User

right-click on values and choose the agg option you want and see, Screenshot 2019-09-27 16.19.24.pngif it resolve your issue.

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

Hi @amitchandak 

 

Thank you for your response.. But i didn't get your solution. can you please explain little mor

 

Thank you in advance

 

Anonymous
Not applicable

Hi,

 

Have you tried putting EndDate[]<> BLANK()

Anonymous
Not applicable

Hi @Anonymous,

 

Thank you for your response.. But I have data for Blank End dates also See below image. if two duplicate name comes at that i want to take that criteria otherwise i want to show all if end date is blank also

 

Thank you in advance

 

Regards,

B V S S

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors