Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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,
Solved! Go to Solution.
@LD1 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.
@LD1 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" )
@LD1 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" )
@LD1 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.
User | Count |
---|---|
25 | |
11 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
7 |