DAX - Identify Duplicate Column values

[BIbeginner]

Hi All

How to identify the duplicate values and mark as sequential number (1,2,3...) using Rankx or Row Number Partition by functions.

Thanks

[v-chuncz-msft]

@BIbeginner,

Check replies in links below that use Power Query and DAX.

• https://community.powerbi.com/t5/Desktop/Remove-Rows-in-Dataset-based-on-most-recent-ID-and-email-ad...
• https://community.powerbi.com/t5/Desktop/how-can-I-show-top-3-data-with-a-combined-categories/td-p/1...

[prakash_gautam]

Not sure using Rankx or Row Number but below DAX works well if there is
unique field/id:

dup =
Var pid = Products[UNID]
return CALCULATE (
COUNTROWS ( Products ),
ALLEXCEPT ( Products, Products[EFFECTIVEDATE] ),
pid >= Products[UNID]
)

ALLEXCEPT ( Products, Products[EFFECTIVEDATE] ) is the field you want to find the duplicate by and
you can include multiple fileds here and Products[UNID] is unique filed/row identifier of the products table.

Thanks