How to remove duplicates in table chart

[Anonymous]

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

Thank you in advance

B V S S

[Anonymous]

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"

Hit Like if this helps you to resolve your issue

Nandri

[Anonymous]

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

[Anonymous]

@Anonymous 

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

Try this and let me know 

Nandri

[Anonymous]

Hi @Anonymous,

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

[Anonymous]

@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]

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

Thank you in advance... Waiting for your more suggestions

[Anonymous]

@Anonymous 

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

[amitchandak]

right-click on values and choose the agg option you want and see, if it resolve your issue.

[Anonymous]

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]

Hi,

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

[Anonymous]

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