cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
bvss Member
Member

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
Mvignesh53 Member
Member

Re: How to remove duplicates in table chart

Hi,

 

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

amitchandak Super Contributor
Super Contributor

Re: How to remove duplicates in table chart

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.

 

msksenthil Regular Visitor
Regular Visitor

Re: How to remove duplicates in table chart

Hello @bvss 

 

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
bvss Member
Member

Re: How to remove duplicates in table chart

Hi @msksenthil ,

 

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

bvss Member
Member

Re: How to remove duplicates in table chart

Hi @amitchandak 

 

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

 

Thank you in advance

 

bvss Member
Member

Re: How to remove duplicates in table chart

Hi @Mvignesh53,

 

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

msksenthil Regular Visitor
Regular Visitor

Re: How to remove duplicates in table chart

@bvss 

 

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

 

RemoveDup.jpg

 

Try this and let me know 

 

Nandri

bvss Member
Member

Re: How to remove duplicates in table chart

Hi @msksenthil,

 

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

msksenthil Regular Visitor
Regular Visitor

Re: How to remove duplicates in table chart

@bvss 

 

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

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 450 members 3,739 guests
Please welcome our newest community members: