Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

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 convert...
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

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

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Anonymous

 

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

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

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

    • Kmow's avatar
      Kmow
      Advocate I
      8 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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"

  • fraktol's avatar
    fraktol
    Regular Visitor
    5 years ago

    This should be the solution, because the request was to use DAX, not Power Query M.