Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Aggro
Frequent Visitor

Calculate data without duplicate values and additional decimal issues

Hi 

 

I want to sum the amount column without the duplicated amount and decimal issues.

 

Current Data:    
     
Tracking numberInvoice numberAmount Note (not in the table)
ABCD-1234XYZ7 << Duplicated
ABCD-1234LMN7  
ABCD-1234PQWE1  
ABCD-1235SDA5 << Duplicated
ABCD-1235EWRW5 << Duplicated
ABCD-1235OPWE5  
ABCD-1235TWERT750 decimal issues, which is the 100th  of the other record
ABCD-1235TWERT7.5  
ABCD-1236QOWOE6  
     
     
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  
2 REPLIES 2
danextian
Super User
Super User

Hi @Aggro ,

Sans the notes, how do you know which ones are the duplicates?






Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu.

I don't, but at this time, we want only to sum up one record instead of all (among the duplicate ones). 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.