Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Good morning,
I have a table called "October '23."
I have a list of about 114k entries. I need to count how many times Guy 1, Guy 2, Lady 1, etc occur in the table based on their user ID. Below is my expected output.
Thank you,
@parry2k help me please, or anyone else!
Best,
Cam
Solved! Go to Solution.
For your reference.
I make a matrix below.
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |