Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I am looking for a formula to convert values with corresponding currency into a new column which shows all values in NOK. See example below:
Value1 Currency ValueNOK
100 USD 796
200 EUR 2000
300 NOK 300
Following formula ValueNOK = IF('Table1'[Currency]= "USD"; 7,96*'Table1'[Value1];0) works fine for converting rows with USD, but how do I also include EUR and NOK?
br
Stian
Solved! Go to Solution.
One way is just to keep on stacking if formulas for each currency code you have.
Example.
USD | 7,96 |
EUR | 10 |
NOK | 1 |
One way is just to keep on stacking if formulas for each currency code you have.
Example.
USD | 7,96 |
EUR | 10 |
NOK | 1 |
Thanks ! This worked perfectly !
You can use Switch:
ValueNOK = Swtich (true (), Currency = "USD"; 7,96*'Table1'[Value1]; Currency = "EUR"; *Table [Value1]; Currency = "NOK"; *Table [Value1];0)
Next to each currency put the number that you want to multiply with value1 🙂
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |