Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
15 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
29 | |
3 | |
3 | |
2 | |
2 |