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.
Dear Experts,
I have a table as below.
I would like to transform above table to be usable in power query as below.
Please help me to transfrom the table in power query. Thank you.
Regards,
Kyaw Myo Tun
Solved! Go to Solution.
just for the sample data
NewStep=Table.FromPartitions("Department",Table.Group(PreviousStepName,"Name",{"n",each {[ID]{0},Table.Skip(_)}},0,(x,y)=>Byte.From(y=null or y=""))[n])
just for the sample data
NewStep=Table.FromPartitions("Department",Table.Group(PreviousStepName,"Name",{"n",each {[ID]{0},Table.Skip(_)}},0,(x,y)=>Byte.From(y=null or y=""))[n])
Hi @wdx223_Daniel ,
This is working perfectly. Thanks for your help.
Regards,
KMT