Forum Discussion
Solved
Look for a Way to Display Duplicate Line Items for Auditing
Hello all, I'm looking to use PBI to audit duplicate entries for payment reimbursements. Say I have a table with 3 columns, "Employee", "Line Item", "Amount". I have figured out how to search t...
Do a group by with all the columns being key columns. Add the aggregate of Count. Then filter on Count > 1.
Do a group by with all the columns being key columns. Add the aggregate of Count. Then filter on Count > 1.
Thank you!