Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Solved! Go to Solution.
Hi @afif_hazim ,
In your case, you just add a custom column contains the table and then expand it.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @afif_hazim ,
In your case, you just add a custom column contains the table and then expand it.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@afif_hazim Please refer below M Code. I hope this helps you. Thank you!!
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8krMU9JRMlSK1YlWcktNArKNwGzfxCIg2xjMdiwAsU2g4pVAtimY7VUK0msGZecA2eYQ9aXpQLYFmB2cWgBkW4LZ/sklILsMwBy//DIQB2KzS2oyiAO0OhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Month Name" = _t, #"Month Index" = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Month Name", type text}, {"Month Index", Int64.Type}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Partners", each #"Talent Partners"),
#"Expanded Partners" = Table.ExpandTableColumn(#"Added Custom", "Partners", {"TP"}, {"Partners.TP"})
in
#"Expanded Partners"