Forum Discussion
Finding Duplicates
Hi Everyone,
Is there a way to filter out duplicates in this table? Thank you in advance.
Sample:
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
4 Replies
Hello houston39 ,
there are ways to filter out duplicates. But please be a little bit more specific.
Do you want to filter out duplicates of VENDORID? Or duplicate rows, like VENDORID, DOCAMNT, Year, Month, Day are exactly the same?
How should the result look like?
As you are already using a table the duplicates are usually already summed up.
Best regards
Denis
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.
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
