Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Community!
I need some kind of multi transpose from a column:
Example File here: https://edvadamsde-my.sharepoint.com/:x:/g/personal/adams_edv-adams_de/EcJEphvMqcdGo4MbaM8iMw8BJoC4i...
Thanks and regards,
Michael
Solved! Go to Solution.
just for the data you shown
=#table(4,List.Split(PreviousStepName[Column1],4))
just for the data you shown
=#table(4,List.Split(PreviousStepName[Column1],4))
Thanks a lot for this elegant solution!
This is awesome. Never thought of using List.Split ever. You taught me this trick. Thank you, so much.
it's my pleasure.
Add an Index column
Add a custom column using Number.IntegerDivide to divide the Index Column by 4 (as you have groups of 4).
Add a custom column(name it Heading) using Number.Mod([Index], 4) to create the field which we will use for column headings.
Then remove the Index column
Then Pivot the Heading column (pick the original column for Values column and Don't Aggregate)
--
That's the method. Have a go and I can help if you get stuck (There will be exact examples on this forum or the web too)
Nice approach, it worked, thanks a lot!