Forum Discussion
ssbagley
Helper III
Helper IIIHow to identify duplicates - same amount and date
I am working with employee expense submissions and want to identify lines for the same date and amount and count the number of "duplicates" identified, by employee. I'm relatively new to PowerBi and...
ssbagleyHelper III
Helper IIII added the index column and we're getting closer; however, the "duplicate exists" flag is appearing any time there are two amounts on the same day for the same person. The amounts need to be the same.
So, person 1 submitted $5 twice on 09/19/2019 = duplicate. I would expect to see
Person 1 $5 09/19/2019
Person 1 $5 09/19/2021
Here is a screenshot from my data with the index column option, but the lines highlighted in yellow are not true duplicates:
