Dynamically currency format symbol

[koorosh]

Hello Experts, There is a table including two columns 'Value' and 'Currency'. I wrote a measure 'Invoice' and following DAX to get dynamic currency format . But as you see the result is not correct. Could you please help?

Invoice =

var _invoice = [Value]/100

return

FORMAT(_invoice,

SWITCH(

SELECTEDVALUE('Table'[Currency],"USD"),

"USD","$#,##0.##",

"GBP","£#,##0.##",

"EUR","€#,##0.##",

"AUD","A$#,##0.##",

"NZD","OZ#,##0.##",

"CAD","C$#,##0.##"

)

)

[amitchandak]

@koorosh , seem like this has a similar problem solution https://radacad.com/dynamically-change-the-format-of-values-in-power-bi

[koorosh]

I tried from that link, but I did not make a separate parameter table for currency. I try to use the table in the model that has a currency column. Do you get my mean?

[v-kelly-msft]

Hi  @koorosh ,

Is your issue solved now?

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

[v-kelly-msft · Accepted solution]

Hi @koorosh ,

Try:

Invoice =
var _invoice = [Value]/100
return
SWITCH(
SELECTEDVALUE('Table'[Currency],"USD"),
"USD",FORMAT(_invoice,"$#,##0.##"),
"GBP",FORMAT(_invoice,"£#,##0.##"),
"EUR",FORMAT(_invoice,"€#,##0.##"),
"AUD",FORMAT(_invoice,"A$#,##0.##"),
"NZD",FORMAT(_invoice,"OZ#,##0.##"),
"CAD",FORMAT(_invoice,"C$#,##0.##")
)
)

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!