Forum Discussion
Finding Duplicates
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
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
Hi,
To your visual, drag VendorID, Day, Month and Year to the visual. Write this measure
=min(data[DocAmt])
