Currency Formatting

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

Theo,

DimCurrencyRates table is shown below.

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