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.
Hello,
I want to know how I can create Table C from Table A in Power Query.
Using Unpivot, I come to have Table B, now I am struggling to find a solution to create Table C.
Please help!
Table A
Table B
Table C
Solved! Go to Solution.
I have solved this!!
First, select date columns and 'Unpivot Column'
then, select item column and 'Pivot Column'
done!
Hi @bodol32
It looks like you just have to pivot Item and Value in table B and that should be it. If you paste the first table here in text-tabular form (instead of a creen capture) I can run a quick test and post the exact steps (if you do need that ).
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs
Cheers
Hey AiB
Thank you for sharing your experties here.
Site | Item | 1/1/2019 | 2/1/2019 |
Site A | aaa | 10 | 8 |
Site A | bbb | 20 | 16 |
Site B | aaa | 15 | 12 |
Site B | bbb | 25 | 20 |
Site C | aaa | 5 | 4 |
Site C | bbb | 6 | 4.8 |
I have solved this!!
First, select date columns and 'Unpivot Column'
then, select item column and 'Pivot Column'
done!
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.