Forum Discussion
Custom Column Divide Calculation
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]
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]
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]