Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
I have many columns of same table
Table A
Monthly Plan Weekly plan Actual Monthly Plan1 Weekly plan 2 Actual3
A B C D E F
I wanted them as :
Monthly Plan Weekly plan Actual
A B C
D E F
I can not create a sperate table and append it because there are so many columns and i cant create too many tables.
Solved! Go to Solution.
NewStep=#table(List.FirstN(Table.ColumnNames(PreviousStepName),3),List.TransformMany(Table.ToRows(PreviousStepName),each List.Split(_,3),(x,y)=>y))
NewStep=#table(List.FirstN(Table.ColumnNames(PreviousStepName),3),List.TransformMany(Table.ToRows(PreviousStepName),each List.Split(_,3),(x,y)=>y))
Thanks ,I am not sure If I can understand this code properly,can you please explain a bit more