Add New Row which the result of division other row in Power Query

[Anonymous]

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!

[Anonymous]

This is brilliant! Thank you

[FreemanZ · Accepted solution]

hi @Anonymous 

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