Forum Discussion

houston39's avatar
houston39
Helper I
5 years ago
Solved

Finding Duplicates

Hi Everyone,   Is there a way to filter out duplicates in this table?  Thank you in advance.   Sample:    
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    5 years ago

    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:

     

    Result:

     

     

    Could you show us more details about the problem?

     

    Best Regards

    Allan

     

     

houston39's avatar
houston39
Helper I
5 years ago

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.

 

 

v-alq-msft's avatar
v-alq-msft
Community Support
5 years ago

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:

 

Result:

 

 

Could you show us more details about the problem?

 

Best Regards

Allan