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