Forum Discussion

wneiton's avatar
wneiton
Resolver I
7 years ago
Solved

Identify duplicate and create new table

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!

 

Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    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

     

4 Replies

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    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's avatar
      wneiton
      Resolver I
      7 years ago

      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's avatar
        v-cherch-msft
        Microsoft Employee
        7 years ago

        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