Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have duplicated ID. I want to count the duplicate value for 1st ID= 1, 2nd ID= 2, 3rd ID =3 in power query. how to count for this.
Solved! Go to Solution.
g = Table.Group(Source, {"Code"}, {{"rows", each Table.AddIndexColumn(_, "UniquedCount", 1, 1)}}),
z = Table.Combine(g[rows])
g = Table.Group(Source, {"Code"}, {{"rows", each Table.AddIndexColumn(_, "UniquedCount", 1, 1)}}),
z = Table.Combine(g[rows])
User | Count |
---|---|
19 | |
10 | |
10 | |
9 | |
7 |