The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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