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] )

View solution in original post

9 REPLIES 9
CheenuSing Super Contributor
Super Contributor

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] )

View solution in original post

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

Highlighted
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. 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 55 members 1,031 guests
Please welcome our newest community members: