You’re offline. This is a read only version of the page.
Hi everyone,
I need help getting rid of the duplicate Serial Numbers as such:
This is the raw data table. When the Serial Number is duplicated, I would like to keep the row NOT containing INAC
| SerialNumber | Equipment_Status__c |
| 110009587 | DLFL,INAC,ECUS |
| 110009587 | AVLB |
| 110010586 | INAC,ECUS,DLFL |
| 110010586 | AVLB |
| 804469 | DLFL,AVLB |
| 804469 | INAC,DLFL,AVLB |
| 1258692 | INAC |
| 5462138 | DLFL,AVLB |
| 213685 | INAC,ECUS,DLFL |
This is what that table would look like:
| SerialNumber | Equipment_Status__c |
| 110009587 | AVLB |
| 110010586 | AVLB |
| 804469 | DLFL,AVLB |
| 1258692 | INAC |
| 5462138 | DLFL,AVLB |
| 213685 | INAC,ECUS,DLFL |
Can anyone solve this? Please break it down cause I'm fairly new to Power BI
Thanks in advance!
#1
lbendlin
2
Super User 2025 Season 1
#1
mmbr1606
2
Super User 2025 Season 1
#1
ronaldwalcott
2
Share
Report
All responses (
Answers (