Identify duplicate and create new table

[wneiton]

Hi dear, 

I just want to identify duplicate values in my rows and create another table with this duplicate values, I will give an example. 

I have this table. 

 

As you can see there are duplicate values. As a result I would like that table below. 

Thanks!

[v-cherch-msft]

Hi @wneiton

You may try to add a calculated column as below:

Dup =
COUNTX (
    FILTER ( 'sample', 'sample'[valores] = EARLIER ( 'sample'[valores] ) ),
    'sample'[final_notas]
)

Then you may get a table use DAX or get a table visual as below:

Table:

Table 2 =
SELECTCOLUMNS (
    FILTER ( 'sample', 'sample'[Dup] = 2 ),
    "final_notas", 'sample'[final_notas]
)

Table visual:

 

Regards,

Cherie

[wneiton]

Hi @v-cherch-msft

valores is a calculated column, then it does not appears here 

EARLIER ( 'sample'[valores] ) ),

is there a way to turn it around?

thanks!

[v-cherch-msft · Accepted solution]

Hi @wneiton

I've tested with calculated column as below. It seems nothing wrong with the formula. If it is not your case, please share your data sample file. You can upload it to OneDrive or Dropbox and post the link here.

Regards,

Cherie

[Vvelarde]

@wneiton

Hi, do you want a table or a table visual.?

Regards

Victor