Avoid duplicates

Your format is taking the distinct combination of column1, comments and dates combined. So something like:

are being counted as 2 different entries. 

If you want to keep the latest entry per column 1 value, consider something like:

Table =
FILTER (
    'TABLE',
    'TABLE'[RecDate]
        = CALCULATE (
            MAX ( 'TABLE'[RecDate] ),
            ALLEXCEPT ( TABLE, 'TABLE'[PartNumber] )
        )
)

or consider how else you want to determine which of the duplicate values to keep.