Forum Discussion
Check Duplicates Values
Hi guys, I have a table called "flancamento" and I would like to find duplicate rows. I thought of a solution that would return duplicate values in a new column. Then I am creating a calcu...
Hi, karinafreitass , you might want to try this measure in a calculated column
RESULT = IF ( CALCULATE ( COUNTROWS ( flancamento ), ALL ( flancamento[Index] ) ) > 1, "Duplicated" )
flancamento[Index] is the first column in your dataset with cardinal numbers 1, 2, 3 ...
Thanks for help.
I've identified a problem. In the visual (table) I identified that the power Bi is generating duplicity as 1 record only and is making the sum of the values. So there's not going to be duplicate values, and that's not cool.
I need to identify if there are duplicate records in the entire row