cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cousinlarry Regular Visitor
Regular Visitor

DAX function for converting a number into a string?

I have a string (url) and a number (pagination), I need to concatenate them into a resulting URL. 

 

I have search and looked at the VALUE and FORMAT dax functions but can't make it work in converting a number into a string. e.g.

 

"http://www.xyz.com?page=" & [page] 

returns an error  "We cannot apply operator & to text and number. 

 

Any clues how I can convert [page] to a string?

 

1 ACCEPTED SOLUTION

Accepted Solutions
cousinlarry Regular Visitor
Regular Visitor

Re: DAX function for converting a number into a string?

Thanks, ended up using Text.From( [Counter] )

9 REPLIES 9
Highlighted
Super User
Super User

Re: DAX function for converting a number into a string?

@cousinlarry

 

try using 

"http://www.xyz.com?page=" & Format([page] ,"####")

 

If this works please accept as a solution and also give Kudos. If it does not work let me know what happened.

 

Cheers

 

 

 

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
cousinlarry Regular Visitor
Regular Visitor

Re: DAX function for converting a number into a string?

Thanks, ended up using Text.From( [Counter] )

v-haibl-msft Super Contributor
Super Contributor

Re: DAX function for converting a number into a string?

@cousinlarry

 

You can also do the concatenation by “Merge Columns” in Query Editor. Select these two columns and click “Merge Columns”.

DAX function for converting a number into a string_1.jpg

 

Best Regards,

Herbert

Re: DAX function for converting a number into a string?

= "Text" & Number.ToText(Number)

joopiest Frequent Visitor
Frequent Visitor

Re: DAX function for converting a number into a string?

Wow, That's pretty easy. 

Thanks

Kmow Frequent Visitor
Frequent Visitor

Re: DAX function for converting a number into a string?

Format() is the correct answer. What you've used is not DAX

atrinhatra Member
Member

Re: DAX function for converting a number into a string?

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"

Kmow Frequent Visitor
Frequent Visitor

Re: DAX function for converting a number into a string?

Not sure I'm fully understanding you @atrinhatra

 

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. 

 

josephr Visitor
Visitor

Re: DAX function for converting a number into a string?

Yes, this is easy to pull off in Power Query.  If you need to do this in the model (for instance, off of a calculated table), the correct DAX would be to use FIXED(<number>,3,1) to convert the number into string at 3 decimals and then RIGHT(<>,3) to retun the right 3 decimals.