Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi - I am new to Power BI and need a solution to combine BrandLabel if interchangePartNumber is identical for a respective partNumber. I have shown below two tables below to display the raw data and desired output for better understanding. Thank you.
RAW DATA:
PartNumber | BrandLabel | InterchangePartNumber |
51-53HK | Precision | 269 |
51-53HK | Precision | 280 |
51-53HK | Moog | 269 |
51-53HK | Moog | 280 |
51-53HK | MasterPro | 269 |
51-53HK | MasterPro | 280 |
51-53HK | Badger | 8307-2198 |
51-53HK | Midwest | 5-153XR |
67-90CN | Navistar | ETN 010608 |
67-90CN | Paccar Parts | ETN 010737 |
67-90CN | Volvo Cars | 5EX162 |
67-90CN | Peterbilt | 5EX162 |
67-90CN | Navistar | 280 |
67-90CN | McNeilus | 280 |
Desired Output:
PartNumber | BrandLabel | InterchangePartNumber |
51-53HK | Precision/Moog/MasterPro | 269 |
51-53HK | Precision/Moog/MasterPro | 280 |
51-53HK | Badger | 8307-2198 |
51-53HK | Midwest | 5-153XR |
67-90CN | Navistar | ETN 010608 |
67-90CN | Paccar Parts | ETN 010737 |
67-90CN | Volvo Cars/Peterbilt | 5EX162 |
67-90CN | Navistar/McNeilus | 280 |
Kind regards,
Solved! Go to Solution.
Hi,
This measure works
Labels = CONCATENATEX(VALUES(Data[BrandLabel]),Data[BrandLabel],"/")
Hope this helps.
Hi,
This measure works
Labels = CONCATENATEX(VALUES(Data[BrandLabel]),Data[BrandLabel],"/")
Hope this helps.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
72 | |
38 | |
31 | |
26 |