07-17-2016 08:10 PM
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?
Solved! Go to Solution.
07-17-2016 09:17 PM
"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.
07-18-2016 07:50 PM
You can also do the concatenation by “Merge Columns” in Query Editor. Select these two columns and click “Merge Columns”.
11-15-2018 07:07 AM
HOw to you use this FORMAT() function in example?
lets say if you have two columns where you are appling into a meaure
newmeasure = viewname[columnnameingar] and viewname[newcolumnstring] , "a stringvalue"