Forum Discussion

karinafreitass's avatar
karinafreitass
Icon for Helper III rankHelper III
6 years ago

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...
Need Help
CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
6 years ago

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 ...

karinafreitass's avatar
karinafreitass
Icon for Helper III rankHelper III
6 years ago

@CNENFRNL

@amitchandak

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