Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi, I have got table 1 and I want make Table 2. Does anyone knows how to do?
Thankx!
Solved! Go to Solution.
Thankx Stéphane for the code, does I add a custom column? Or where Can I add the code, in M?
No, just add a new step and replace "Your_Source" by your "previous step"
No, just add a new step and replace "Your_Source" by your "previous step"
Thanks, I haven already solved it.
Hi,
Table.Group(
Your_Source,
{"Column 1"},
{ {"Column 2", each Text.Combine([Column 2], " / ")},
{"Column 3", each List.Sum([Column 3])}},
GroupKind.Local,
(x,y) => Byte.From(y[Column 1] <> null))
Stéphane
Thankx Stéphane for the code, does I add a custom column? Or where Can I add the code, in M?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.