Loading...

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

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 more
Dynatecon Solutions
Dynatecon Solutions

Let's talk about quick and affordable digital transformation

Share post:

Related posts

Business Central 2025 wave 2 (BC27): Access open-sourced Power BI apps

Hi, Readers.Dynamics 365 Business Central 2025 wave 2 (BC27) is generally available. More details: General Available: Dynamics 365 Busine...

7 hours ago

Snowflake Query Tags In Power BI And Workspace Monitoring

Since I wrote about the Snowflake query tags generated by Power BI earlier this year, one important piece of functionality has been added: an ...

13 hours ago

How to quickly find rows with errors in Power Query when using Power BI

In the past when there has been an error when loading data into the semantic model, there can be times when clicking on the View errors can ei...

5 days ago

Wave 1 Highlights: What Power Automate & Power BI Offer You This Year

The Microsoft Power Suite has been redefining digital transformation for businesses across industries. Every year, Microsoft introduces fresh ...

11 days ago

Power BI in Teams – Content Shared in Teams Chats Now Opens a Dedicated Separate Window Within Teams

Power BI in Teams – Content Shared in Teams Chats Now Opens a Dedicated Separate Window Within Teams

12 days ago

DAX UDFs: Code once, reuse everywhere (Preview)

Discover the power of DAX User Defined Functions (UDFs) in Power BI! Now in public preview, DAX UDFs let you define reusable logic with parame...

12 days ago

DAX UDFs: Code once, reuse everywhere (Preview)

Discover the power of DAX User Defined Functions (UDFs) in Power BI! Now in public preview, DAX UDFs let you define reusable logic with parame...

12 days ago

Microsoft Dynamics 365 Customer Experience Analyst : Embed Power BI dashboard, reports, and tiles

 In Power BI, dashboards, reports, and tiles are key building blocks that present and organize data insights. A dashboard is a single-pag...

13 days ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy