Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.