Forum Discussion

koorosh's avatar
koorosh
Post Partisan
4 years ago
Solved

Dynamically currency format symbol

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.##"
)
)

 

Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    4 years ago

    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!

4 Replies

    • koorosh's avatar
      koorosh
      Post Partisan
      4 years ago

      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's avatar
        v-kelly-msft
        Community Support
        4 years ago

        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!