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.
Can this be possible to change the currency value (not symbol) based on the user selection?
For example:
Product Price
P1 10
P2 20
User Choosing Currency1= Price * Exchange Rate (10.45) or if user choose Currency2 = Price * Exchange Rate (11.44)
Result set
Product Price(Converted)
P1 *****
P2 *****
please help.
Solved! Go to Solution.
@gpraveenonline What you need to do is import currency lookuptable into power bi desktop which has currency code, conversion_rate columns. Then, create a slicer with currency code values and create a measure which looksup the conversion rate and multiplies with Price column of actual table based on user selection on slicer. You can use HASONEVALUE and FIRSTNONBLANK function to identify user selection and then perform lookup based on that for the conversion.
Hope that make sense.
selectedValue =
IF (
ISFILTERED ( 'calculations'[val] ) && HASONEVALUE ( 'calculations'[val] ),
LASTNONBLANK ( 'calculations'[val], 0 ),
MIN(products[price]) * MIN('calculations'[val])
)
CurrencyType | Rate |
Euro | 40000 |
IRR | 1 |
Dollar | 35000 |
Default currency= IRR
CurrencyConversion = SWITCH(VALUES(Currency_Table[CurrencyType]),"Euro",[Euro],"Dollar",[Dollar],"IRR",1)
@gpraveenonline What you need to do is import currency lookuptable into power bi desktop which has currency code, conversion_rate columns. Then, create a slicer with currency code values and create a measure which looksup the conversion rate and multiplies with Price column of actual table based on user selection on slicer. You can use HASONEVALUE and FIRSTNONBLANK function to identify user selection and then perform lookup based on that for the conversion.
Hope that make sense.
Hello,
I have the same issue than gpraveenonline but his DAX formula in the reply doesn't work in my case. Could you please help me with the formula writing ?
Thank you,
selectedValue =
IF (
ISFILTERED ( 'calculations'[val] ) && HASONEVALUE ( 'calculations'[val] ),
LASTNONBLANK ( 'calculations'[val], 0 ),
MIN(products[price]) * MIN('calculations'[val])
)
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |