REQUIREMENT: Compress multiple row values in a single cell value of a table or matrix using CONCATENATEX function in Power Bi as shown in the Fig.1 Fig.1 SOLUTION: Step1: Import table using Getdata in Power BI Desktop as shown in Fig.2 Fig.2 Step2: Add relationships between the tables as shown in Fig.3. There are two…