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…
Published on:
Learn moreRelated posts
Calculated Columns vs Measures in DAX
Level: Beginners Original: Feb 2016 It has been many years since Matt wrote his first take on Calculated Columns vs Measures, back in 2014 whe...
11 hours ago
Unlock the Secrets to Power BI Mastery!
17 hours ago
Can Marthe fix Patrick's Power BI Report?
17 hours ago
Fabric Copilot to help write DAX queries improvements
This update comes with a marked improvement when generating DAX queries and conversationally editing them. This includes overall correctness o...
23 hours ago
Datamart are dead.
1 day ago
Unify Datamart with Fabric Data Warehouse!
The unification of Power BI datamarts with Fabric data warehouses offers a significant evolution in Microsoft’s analytics capabilities. ...
1 day ago