Forum Discussion
Format string
In the following table as example : Table1 column -1,14 -0,07 0,67 1,00 -2,77 which format string should be used to get this result: column -1,14% -0,07% 0,67%...
One solution is to change the column to percentage directly from DATA >>Column Tools >> Formatting.
you can also format your column using DAX
Column = FORMAT(DIVIDE(Sheet1[Profit],10000),"percent")
And if you want to convert "," to "." then use the following DAX, and to convert it into percentage use the above steps.
column = SUBSTITUTE(Sheet1[Profit],",",".")