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.
I have table as follow, want to convert the "Account" as row. What is the best way to transform this? Thanks.
Current:
Site # | Year | Month | Account | Value |
Site 1 | 2019 | January | Count1 | 100 |
Site 2 | 2019 | January | Count2 | 200 |
Site 3 | 2019 | January | Count3 | 300 |
Site 1 | 2019 | February | Count1 | 100 |
Site 2 | 2019 | February | Count2 | 200 |
Site 3 | 2019 | February | Count3 | 300 |
Site 1 | 2020 | January | Count1 | 100 |
Site 2 | 2020 | January | Count2 | 200 |
Site 3 | 2020 | January | Count3 | 300 |
Post:
Site # | Year | Month | Count1 | Count2 | Count3 |
Site 1 | 2019 | January | 100 | 200 | 300 |
Site 1 | 2019 | February | 100 | 200 | 300 |
Site 1 | 2020 | January | 100 | 200 | 300 |
Solved! Go to Solution.
Hi @Tevon713 ,
I have not gotten to the post result you wished for, but here somethinng that maybe gets you closer to a solution:
What I did was that I pivoted on the Account column using the Value column as value. To do this, mark the Account column and click on Pivot column in the transform section:
What puzzles me is how you would want to return 200 for Site 1 in the Column Count2, since in your raw data Site 1 never has the attribute Count2. Same thing for Count3...
Hope this helps you anyway 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
Hi @Tevon713 ,
I have not gotten to the post result you wished for, but here somethinng that maybe gets you closer to a solution:
What I did was that I pivoted on the Account column using the Value column as value. To do this, mark the Account column and click on Pivot column in the transform section:
What puzzles me is how you would want to return 200 for Site 1 in the Column Count2, since in your raw data Site 1 never has the attribute Count2. Same thing for Count3...
Hope this helps you anyway 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
Hi @tackytechtom.,
Thanks for your help. Sorry I typed up too quick. The result you showed is correct.
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.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |