cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Helper III

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

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

)

How could I achieve this result?

Thanks,

Karina

4 REPLIES 4
Community Support

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.

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

@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())

Tutorial Series Dax Vs SQL Direct Query PBI Tips

Community Champion

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 to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! DAX is simple, but NOT EASY!
Helper III

@CNENFRNL

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

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors