Custom Column Divide Calculation

[Anonymous]

Hi Experts

How can i change the following measure into a Custom Column in Power Query - from a Calculated Column - Currently

= DIVIDE([Shipping_Amount],[total_qty_ordered],0)*[Exchange_Rate]

[Anonymous · Accepted solution]

Assuming that division is at a row level and that all columns are on the same table, type the following formula in the Custom Column pop up box:

([Shipping Amount]/[Total Quantity Ordered])*[Exchange Rate]