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 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
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 |
---|---|
107 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
142 | |
105 | |
103 | |
85 | |
70 |