Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Check replies in links below that use Power Query and DAX.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
23 | |
3 | |
2 | |
2 | |
2 |