Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Currency Formatting

Thank you to all who respond,   My goal is to show the currency symbol for US and Euro when the slicer is selected. The slicer is working correctly but I can't seem to get the correct DAX for forma...
Need Help
  • TheoC's avatar
    TheoC
    4 years ago

    Hi Anonymous 

     

    How have you structured your DimCurrencyRates table?  Does it include a Format column within it?  If not, certainly recommend it. From there, you can incorporate LOOKUPVALUE with CONCATENATE.

     

    Link to an article that explains it in some detail: https://blog.enterprisedna.co/format-currencies-in-power-bi-using-dax/

     

    Hope this helps.

    Theo

     

     

  • Anonymous's avatar
    Anonymous
    4 years ago

    Theo,

     

    DimCurrencyRates table is shown below.

     

     

  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi Anonymous  ,

     

    You can try this:-

     

    FORMAT_Sales = 
SWITCH(
SELECTEDVALUE('DimCurrencyRates'[Fullname]),
"US Dollar",FORMAT([Converted Sales],"$#,##0"),
"EURO",FORMAT([Converted Sales],"€#,##0")
)

     

     

    Thanks,

    Samarth

Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

Hi Anonymous  ,

 

You can try this:-

 

FORMAT_Sales = 
SWITCH(
SELECTEDVALUE('DimCurrencyRates'[Fullname]),
"US Dollar",FORMAT([Converted Sales],"$#,##0"),
"EURO",FORMAT([Converted Sales],"€#,##0")
)

 

 

Thanks,

Samarth