Forum Discussion
Stacking multiple columns into single column in a table
I would like to combine multiple columns from a seperate table into a single column in a new table, but I haven't found a way to do that in the table editor with dax. If I had the table in figure 1 h...
Hello Anonymous ,
Assuming you have no problem using power query,
Make duplicate of say original table 1 as table 2.
Remove column value 3 and value4 from table1. Rename value 3 and 4 in table 2 as value 1 and value 2.
Then append table 2 in table 1 and you are done.
I can post an example file if it is acceptable but you would like to see an example.
You may check with your actual scenario, theoretically it should work fine. Additionally, you should disable load of all such copies, so final data model shall only contain your desired table. This way your data size is optimised and user don't see spare tables.