Forum Discussion

gpraveenonline's avatar
gpraveenonline
Frequent Visitor
10 years ago
Solved

Multi Currency Based by user selection with slicer?

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...
Need Help
Show and Tell
Tips and Tricks
  • ankitpatira's avatar
    ankitpatira
    10 years ago

    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.

  • gpraveenonline's avatar
    gpraveenonline
    10 years ago

    selectedValue =
    IF (
    ISFILTERED ( 'calculations'[val] ) && HASONEVALUE ( 'calculations'[val] ),
    LASTNONBLANK ( 'calculations'[val], 0 ),
    MIN(products[price]) * MIN('calculations'[val])
    )

ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
10 years ago

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.

  • gpraveenonline's avatar
    gpraveenonline
    Frequent Visitor
    10 years ago

    selectedValue =
    IF (
    ISFILTERED ( 'calculations'[val] ) && HASONEVALUE ( 'calculations'[val] ),
    LASTNONBLANK ( 'calculations'[val], 0 ),
    MIN(products[price]) * MIN('calculations'[val])
    )

  • Aroth's avatar
    Aroth
    Icon for Advocate II rankAdvocate II
    9 years ago

    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,