Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

 

 

Thank you in advance

B V S S

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks

11 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        Anonymous
        Not applicable
        6 years ago

        Anonymous 

         

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

         

         

        Try this and let me know 

         

        Nandri

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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