Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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]

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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]

     

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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]