Forum Discussion
YanmarJS
8 years agoFrequent Visitor
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
- quentin_vigneSolution Sage
Hi YanmarJS
Right clik on your table > add new column
Column = DIVIDE(YourTable[SalesPrices];YourTable[Ex Rate]) * YourTable[Ord Qty]
- Quentin