undefined

[Diksha]

I have a table with date column and To, From and CC emails columns. I want to keep date column and second column include first TO values then FROM values then CC values in powerBI.

[Anonymous · Accepted solution]

Hi @Diksha 

You can refer to the following example.

You can put the following code to advanved editor in power query

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjIwMtY31DdU0lFyBGInIHZWitVBkYAIghTAJYxQdLhgkwhDlTAGSziDBVGMMoFLuAKxm1JsLAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Date = _t, To = _t, From = _t, CC = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type date}, {"To", type text}, {"From", type text}, {"CC", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each "To"&":"&[To]&"  "&"From"&":"&[From]&"  "&"CC"&":"&[CC]),
    #"Grouped Rows" = Table.Group(#"Added Custom", {"Date"}, {{"Content", each Text.Combine([Custom],"; ")}})
in
    #"Grouped Rows"

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dufoq3]

I want world peace...