How to concatenate multiple rows from an other table in DAX?
0 I'm new to Power BI and I need to concatenate in a new column Suppliers_List all the suppliers for a given item. I have a table Orders where I need to create the column : Order_Number Customer_ID Item_Number 0001 1 1 0002 2 1 0003 1 3 0004 1 4 0005 3 2 0006 3 2 0007 4 2 A table Items where a same product can have multiple supplier: Unique_ID Item_Number Supplier_ID Item_Name 1 1 1 "wheel" 2 1 2 "wheel" 3 2 1 "door" 4 2 2 "door" 5 3 1 "motor" 6 3 3 "motor" 7 4 4 "dashboard" And a table Suppliers : Supplier_ID Supplier_Name 1 "Metal&co" 2 "SmithSE" 3 "BetterMotors" 4 "TinyCircuits" I'm trying to get the following result in the table Orders where I store the suppliers name, separated by a comma : Order_Number Customer_ID Item_Number Suppliers_List 0001 1 1 "Metal&co, SmithSE" 0002 2 1 "Metal&co, SmithSE" 0003 1 3 "M...