Forum Discussion
DAX function for converting a number into a string?
Thanks, ended up using Text.From( [Counter] )
Format() is the correct answer. What you've used is not DAX
HOw to you use this FORMAT() function in example?
lets say if you have two columns where you are appling into a meaure
ie
newmeasure = viewname[columnnameingar] and viewname[newcolumnstring] , "a stringvalue"
Not sure I'm fully understanding you Anonymous
General info page on FORMAT: https://docs.microsoft.com/en-us/dax/format-function-dax
Couple examples from: https://docs.microsoft.com/en-us/dax/pre-defined-numeric-formats-for-the-format-function
FORMAT( 12345.67, "General Number")
FORMAT( 12345.67, "Currency")
FORMAT( 12345.67, "Percent")
Combining column values in a measure usually won't work due to context. Unless you first aggregate the columns in some way. Measures yield a single value given a context, so if your context includes multiple rows, then any measure that combines column values without aggregation will error out.
Hope that helps.