Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi there,
I have data organised a bit like this - I just want to take the last three columns and place them directly underneath the first three, like this...
Though I don't want to create two seperate queries and append them! For the real life problem this would mean creating a huge amount of individual queries
Any ideas most appreciated! 🙂
Solved! Go to Solution.
@Anonymous , see if approach of this blog can help
https://kohera.be/blog/power-bi/how-to-unpivot-twice/
Hi, @Anonymous
I have a simple method, just duplicate a table, delete the merged rows in the corresponding table, change the name, and append queries.
Like this:
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , see if approach of this blog can help
https://kohera.be/blog/power-bi/how-to-unpivot-twice/
User | Count |
---|---|
101 | |
90 | |
79 | |
70 | |
69 |
User | Count |
---|---|
112 | |
96 | |
96 | |
75 | |
72 |