Merge Multiple Records for Single Client

Question

I have 1500+ records, with the data pulled in from 4 tables. This means that some of the clients have more than 1 record, although the product is different in each record, so I need to be able to merge all the data for each client into a single record. In addition, I would need to set the Status of the new record to 'Multiple Products'. Is there any way of doing this please? Many thanks.

serpiva64 · Answer

Please make an example with sample data and the desired result&nbsp;

lilacdaffodil · Answer

Apologies - example file can be downloaded here.&nbsp;I have highlighted the merged records in red.Thank you&nbsp;😁

mitutorials · Answer

Try following the below tutorial as a starting point.&nbsp;Combine / Merge Rows based on ID column using power Query in Power BI | MiTutorials - YouTube

Forum Discussion

Merge Multiple Records for Single Client

3 Replies

Related content

multiple or single semantic model

Attach multiple lakehouse to a single notebook.

Single master PBI report for multiple clients

Fabric GraphQl - How to create multiple record under single mutation.

Single Legend for multiple visuals?