Forum Discussion
Display a result formula in a Text function
Hi everyone,
I have request, is it possible to insert a calculate function result in a new mesure Text?
I mean,
New measure : "Today our turnover up to" & [Turnover]
Turnover = Sum of turnover in decimal number format
I tried but the format was deleted automatically.
Ex : formating 5m€ => display 59787878,0909090 in New measure.
Thank you in advance for your help,
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.
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" )
3 Replies
Thank you AntrikshSharma & saurabhtd it works !
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.
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" )