Only display if occurs more than once

[paul_jones]

This seems simple but...  I only  want to display serial number and date if the serial number occurs more than once.

Serial Number	Date
101	3/1/2022
102	3/1/2022
103	3/1/2022
103	4/5/2022
104	5/1/2022
105	4/7/2022
105	5/1/2022
106	3/15/2022

Resulting table would be:

Serial Number	Date
103	3/1/2022
103	4/5/2022
105	4/7/2022
105	5/1/2022

[Shaurya · Accepted solution]

Hi @paul_jones,

You can use this DAX formula:

New Table = FILTER('Table',COUNTX('Table',IF('Table'[Serial Number]=EARLIER('Table'[Serial Number]),'Table'[Serial Number]))>1)

Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: Forecast Period - Previous Forecasts

[mangaus1111]

Hi @paul_jones ,

first you have to create a calculated column:

@Count = COUNTROWS(

                FILTER(

                    'Table',

                    'Table'[Serial Number] = EARLIER('Table'[Serial Number])

                    )

            )

Then you can create your new table:

New Table =

SELECTCOLUMNS(

               CALCULATETABLE(

                              'Table',

                              'Table'[@Count]>1

                              ),

                "Serial Number", 'Table'[Serial Number],

                "Date", 'Table'[Date]

                )

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.