Forum Discussion

YanmarJS's avatar
YanmarJS
Frequent Visitor
8 years ago
Solved

Need Help on multiple exchange rate

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.

 

 

  • Hi YanmarJS

     

    Right clik on your table > add new column

     

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

     

    - Quentin

1 Reply

  • Hi YanmarJS

     

    Right clik on your table > add new column

     

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

     

    - Quentin