Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!