How to add the dollar sign into the dax

[naoyixue1]

Hey there,

Is there any way for me to add dollar sign beore 'Total $' calculation but still keep 'Total U' as unit format w/o dollar sign. I tried to apply value function, but it didn't work. Thanks!

[kameronyork]

Unfortunately columns in PowerBI have to be the same format as defined in the Column settings.  Technically you would be able to have the dollar sign and the number of units if you change the values being returned to Text.

The dollar sign can be added using the concatenate function, then the "Total U" rows would need to be formatted as text either by using the FORMAT function or by adding a space with the concatenate function.

I hope this helps!  If it does, please mark this post as the solution 🙂