Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I want to sum the amount column without the duplicated amount and decimal issues.
Current Data: | ||||
Tracking number | Invoice number | Amount | Note (not in the table) | |
ABCD-1234 | XYZ | 7 | << Duplicated | |
ABCD-1234 | LMN | 7 | ||
ABCD-1234 | PQWE | 1 | ||
ABCD-1235 | SDA | 5 | << Duplicated | |
ABCD-1235 | EWRW | 5 | << Duplicated | |
ABCD-1235 | OPWE | 5 | ||
ABCD-1235 | TWERT | 750 | decimal issues, which is the 100th of the other record | |
ABCD-1235 | TWERT | 7.5 | ||
ABCD-1236 | QOWOE | 6 | ||
Expected Result: | ||||
Tracking number | Expense | Note (not in the table) | ||
ABCD-1234 | 8 | expense is 7 +1 without that duplicate | ||
ABCD-1235 | 12.5 | expense is 5+7.5 without that duplicate and 100th of the record | ||
ABCD-1236 | 6 |
Hi @Aggro ,
Sans the notes, how do you know which ones are the duplicates?
Proud to be a Super User!
I don't, but at this time, we want only to sum up one record instead of all (among the duplicate ones).
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |