Need Help on multiple exchange rate

[YanmarJS]

Hi,

Im still new to Power BI and require some of you guys expertise.

How would I go about on the following columns (excel) that I loaded in Power BI. (see image below)

I am dealing with multiple currency however we do have a fixed exchange rate.

How do I Divide "Sales price" with "Ex Rate" then Multiply (the result) with "Ord Qty" (as shown on the image above) and have the result on a new Column ?

Thanks in advanced.

[quentin_vigne · Accepted solution]

Hi @YanmarJS

Right clik on your table > add new column

Column = DIVIDE(YourTable[SalesPrices];YourTable[Ex Rate]) * YourTable[Ord Qty]

- Quentin