Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team,
Real case question:-
Name Skill
Naveen SQL
Naveen Azure
Naveen Power bi
Srinivas MSBI
Srinivas SQL
Srinivas Power Bi
Result is ;-
Name skill
Naveen SQL,Azure,Power Bi
Srinivas MSBI,SQL,Power Bi
Please check and confirm how we can proceed ?
Insert this step
= Table.Group(Source, {"Name"}, {{"Skill", each Text.Combine([Skill],", "), type text}})
I think this is what your looking for:
https://gorilla.bi/power-query/group-by-to-concatenate-text/
It will give you the result you want. It uses a group by function with the Text.Combine function. It's a really great solution. Credits to gorillabi!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.