Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.