Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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 tu...
DAX
  • saurabhtd's avatar
    saurabhtd
    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.

     

     

  • AntrikshSharma's avatar
    AntrikshSharma
    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" )