Dear All ,
I want a help with a duplicate values. What I need to get is count of the duplicate values as in 1,2,3,4 and so on. And else I need to get the count as 1 (If it is not a duplicate value). Below shows my table.
The results that I need to get is shown below.
Can someone help me to get this result.
@Anonymous use group by.
refer: How to GROUP BY or summarize rows - Power Query | Microsoft Learn
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
@Anonymous use group by.
refer: How to GROUP BY or summarize rows - Power Query | Microsoft Learn
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
