Concatenate Measure & Retain Formatting

[hackfifi]

Hello Good Day,

When i conctatenate a string to a measure "value", the measure "AvgValue" loses its formatting

For example, if the measure [value] result is 100,000

and if i use the below measure:

AvgValue = "The average value is " & [value]

the result is --> The average value is 100000

I am now missing the "," in the number.

Anyway to RETAIN the formatting in the concatenated measure?

Cheers

[Fowmy · Accepted solution]

@hackfifi

Adjust the value with the FORMAT function.

AvgValue = "The average value is " & FORMAT([Value], "0,0")

If you need decimal places, do it "0,0.00"

________________________

If my answer was helpful, consider Accepting it as the solution to help other members find it

Click the Thumbs-Up icon if you like this answer 🙂

Youtube Linkedin