Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hey,
I have a table, where the full text string is splitted up into different rows. Here is an example:
ID Entry No. Text
001 0001 This is a long
001 0002 text which is stored
001 0003 in 3 rows.
002 0001 This is another
002 0002 example
.... .... ....
What I want to retrieve is "This is a long text which is stored in 3 rows.", "This is another example".
Number of rows per text string varies from 1 to 7.
Any suggestion how to concatenate these values?
BR Uli
Solved! Go to Solution.
Hey,
No worries at all, my bad I miss read your question, please find an updated soultion below:
My Data:
My Forumla:
My Table:
Hey,
If you use the following command,
My Dax Forumla:
My Table:
Let me know if you have any furhter questions,
Many Thanks
Ben
Hey Ben,
thanks for quick support. I think your proposal is in right direction, but I still need help: Your example merges all values in column [Test]. I only want to merge those values which have the same ID in another column. In my example all values of column [Text] which share identical value in column [ID] sorted by column [Entry No.].
I'm quite new to Power BI, but I do not see, that your formula resolves that issue. Sorry.
BR Uli
Hey,
No worries at all, my bad I miss read your question, please find an updated soultion below:
My Data:
My Forumla:
My Table:
Thanks a lot - you made my day!
BR Uli
Thank you, happy that I could help 🙂
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
72 | |
38 | |
30 | |
26 |
User | Count |
---|---|
99 | |
87 | |
45 | |
43 | |
35 |