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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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 or follow my page on Facebook @DAXJutsuPBI.

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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