Forum Discussion
Display a result formula in a Text function
- 2 years ago
Anonymous Yes. It is possible. But as you rightly found out whatever format applied to the [Turnover] will be removed.
But if you still want to apply formating like 5m€ this also is possible but we need to modify the logic of [New measure]. You can try this measure .New Measure = "Today our turnover up to " & FORMAT([Turnover], "€#,0,,.00#M")here , FORMAT([Turnover], "€#,0,,.00#M") is used to format the turnover measure with currency symbol, two decimal places and comma as the thousands separator.
- 2 years ago
Anonymous You can use the FORMAT function, you can find more options here: https://dax.guide/format/
"Today our turnover up to " & FORMAT ( [Total Sales], "$#,0.00" ) -- "Today our turnover up to " & FORMAT ( [Total Sales], "Currency" ) -- "Today our turnover up to " & FORMAT ( [Total Sales], "$#,0,,.0#M" ) -- "Today our turnover up to " & FORMAT ( [Total Sales], "$#,0,,,.0#B" )
Anonymous Yes. It is possible. But as you rightly found out whatever format applied to the [Turnover] will be removed.
But if you still want to apply formating like 5m€ this also is possible but we need to modify the logic of [New measure]. You can try this measure .
New Measure = "Today our turnover up to " & FORMAT([Turnover], "€#,0,,.00#M")
here , FORMAT([Turnover], "€#,0,,.00#M") is used to format the turnover measure with currency symbol, two decimal places and comma as the thousands separator.