Data Transformation where interchange part numbers are identical

[raghibakhter]

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,

[Ashish_Mathur · Accepted solution]

Hi,

This measure works

Labels = CONCATENATEX(VALUES(Data[BrandLabel]),Data[BrandLabel],"/")

Hope this helps.