Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I have a table in Power Query which source from other Database as below with Veggie and Milk the main table. I would like to add new row to power query table which is the result of division row Veggie and Milk (as highlighted in Red). Anyone can help me with this? Thanks in advance!
Solved! Go to Solution.
hi @qhpowerbi
try to
1) transpose the table
2) add a custom column with [Viggie]/[Milk]
3) transpose back
about PQ transpose:
https://learn.microsoft.com/en-us/power-query/transpose-table
This is brilliant! Thank you
hi @qhpowerbi
try to
1) transpose the table
2) add a custom column with [Viggie]/[Milk]
3) transpose back
about PQ transpose:
https://learn.microsoft.com/en-us/power-query/transpose-table
User | Count |
---|---|
107 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |