Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi
I have a input table with values as below:-
Form No Value
A M01
A M02
B M03
C M02
C M01
I need the output as below:-
Form No Value
A M01,M02
B M03
C M02,M01
How to do this in Power BI M query?
Thanks
Rviswa
Solved! Go to Solution.
@rviswa
In Power Query, insert a Blank Query, goto Advanced editor clear everything and paste below code,
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcssvylXwyz+0QElHKSwxpzRVKVYnWsnx0AIFGAJK+BoYYhc2Ags7oQsbg4WdsavGEAaaHQsA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Grouped Rows" = Table.Group(#"Promoted Headers", {"Form No "}, {{"NEW COLUMN", each Text.Combine([Value],", "), type nullable text}})
in
#"Grouped Rows"
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thank you. It works.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
69 | |
61 | |
18 | |
16 | |
13 |