Forum Discussion
Stacking Multiple Columns in New Table
Hi!
I'm kinda of new to PBI and DAX and have been trying to resolve a problem for a few days now, without result.
I want to create a new Table where i'll stack multiple columns "on top" of eachother. Let me illustrate.
What i got:
What i want:
I tried using SELECTCOLUMNS and UNION - but I fear that I lack enough knowledge to proceed any furhter.
Do you have any soulutions i could try?
Thank you!
Anonymous , Unpivot in power query - other than date
Split by delimiter into column by _ . for the first column -> that will give, question, answer and comment in more column and number in another column
pivot again using column having question, answer and comment and value
https://radacad.com/pivot-and-unpivot-with-power-bi
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
2 Replies
Anonymous , Unpivot in power query - other than date
Split by delimiter into column by _ . for the first column -> that will give, question, answer and comment in more column and number in another column
pivot again using column having question, answer and comment and value
https://radacad.com/pivot-and-unpivot-with-power-bi
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.Fantastic - With your help I think i can solve the rest!
Thank you amitchandak ! 🙂