How can I Remove double quotes in Power BI Format Function

[vengadesh_p]

Hi All,

i want to show the result in sweden currency format by using dax Format function

power BI Default Currency Format for Sweden is  #,0.00\ "kr";-#,0.00\ "kr";#,0.00\ "kr" , this format has double quotes. but in dax format function will not accepet double quotes. so i tried with out double quotes but it's converted to text so i cant do any calculation by using this measure 

Example : Measure #B = #A +10 but its show error 

But in Power BI Default obtion #B shows 510

[PhilipTreacy · Accepted solution]

Hi @vengadesh_p 

I think you're getting mixed up with format strings and using the FORMAT function.

This is a format string that you use to format the positive;negative;zero values for a given column

#,0.00\ "kr";-#,0.00\ "kr";#,0.00\ "kr"

Whereas using FORMAT allows you to convert a value to text in a given format

FORMAT – DAX Guide

I'm not actually really clear on what you are trying to do.  If you want to show currency in Swedish Krone and the default display format string is #,0.00\ "kr";-#,0.00\ "kr";#,0.00\ "kr" then isn't that doing what you need?

You mention that the format string uses double quotes - this is because it is using "kr" to indicate Krone.

Not sure why you are having an issue?  You don't need to use the FORMAT function, just use the default format string for Swedish Krone.

Regards

Phil