Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello
I am trying to consolidate the Case numbers into a comma-separated list. So I have one UID instead of duplicating it. Case Number Column coming from expanding column from merge table. Can anybody please tell me how do I achieve the below result?
Now
What I want
Thank you so much
Solved! Go to Solution.
@bikelley , if you only want in display then
measure = concatenatex(Table,Table[Case Number])
Display with ID in visual
or try this in power query
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WKjRU0lEyNDJWitWBckxMzRAcUzNzCMcIyDEzReKYm1koxcYCAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ID = _t, Number = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"ID", type text}, {"Number", type text}}),
#"Grouped Rows" = Table.Group(#"Changed Type", {"ID"}, {{"Count", each Text.Combine([Number] , ", "), type nullable text}})
in
#"Grouped Rows"
@bikelley , if you only want in display then
measure = concatenatex(Table,Table[Case Number])
Display with ID in visual
or try this in power query
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WKjRU0lEyNDJWitWBckxMzRAcUzNzCMcIyDEzReKYm1koxcYCAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ID = _t, Number = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"ID", type text}, {"Number", type text}}),
#"Grouped Rows" = Table.Group(#"Changed Type", {"ID"}, {{"Count", each Text.Combine([Number] , ", "), type nullable text}})
in
#"Grouped Rows"
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
93 | |
85 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
132 | |
110 | |
66 | |
55 |