Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |