Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
In an example data set listed below, what is the best way to sum column 2 without taking into account duplicates from A(2) or A(3)? The goal is to only sum up the assignee of each letter only once. Removing duplicates would not work because if 6 was ever assigned to another letter in the future it would be filtered out.
Example Data Set
Column 1 Column 2
A (1) 6
B 8
C 9
A (2) 6
C 9
A (3) 6
Solved! Go to Solution.
@Anonymous ,
Click Query Editor-> Click “Split Column” like below:
After remove useless column, then click "Remove Rows"-> "Remove Duplicates".
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Hope this helps.
@Anonymous ,
Click Query Editor-> Click “Split Column” like below:
After remove useless column, then click "Remove Rows"-> "Remove Duplicates".
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
Go to edit queries.
Right click your column 1 and remove duplicates.
Then sum up your table.
Ta!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |