topic Re: Display a result formula in a Text function in DAX Commands and Tips

Display a result formula in a Text function

Anonymous — Thu, 18 Jan 2024 11:36:10 GMT

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,

Re: Display a result formula in a Text function

saurabhtd — Thu, 18 Jan 2024 12:18:33 GMT

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.

Re: Display a result formula in a Text function

AntrikshSharma — Thu, 18 Jan 2024 12:12:31 GMT

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

Re: Display a result formula in a Text function

Anonymous — Thu, 18 Jan 2024 13:39:16 GMT

Thank you AntrikshSharma & saurabhtd it works !