Check Duplicates Values

[karinafreitass]

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 calculated column  and I am using the following function, but maybe I need to add more parameters:

Duplicados = IF(
                      COUNTROWS(
                               FILTER(fLancamento,fLancamento[Lançamento]=
                                         EARLIER(fLancamento[Lançamento])))>1,1,BLANK()

)

How could I achieve this result?

Thanks,

Karina

[v-yiruan-msft]

Hi @karinafreitass ,

You can achieve it using Power Query or create a calculated column to achieve it, please find all details in the following blogs.

Identify Duplicates Using Power Query

Identify duplicates and show up records

Best Regards
Rena
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.

[amitchandak]

@karinafreitass , Your formula seems fine. Hope you are creating a new column.

You can have new column like

if( countx(filter(fLancamento,fLancamento[Lançamento] =EARLIER(fLancamento[Lançamento])),fLancamento[Lançamento]) >1 , 1, blank())

New measure like

if( countx(filter(allselected(fLancamento),fLancamento[Lançamento] =EARLIER(fLancamento[Lançamento])),fLancamento[Lançamento]) >1 , 1, blank())

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.

[CNENFRNL]

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]

@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