How to Display Duplicate/Repetitive Multiple Rows in a Single Cell of a Table/Matrix in POWER BI 

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…

Continue reading How to Display Duplicate/Repetitive Multiple Rows in a Single Cell of a Table/Matrix in POWER BI