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

v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Anonymous

 

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

 

Best Regards,

Herbert

rafaeloureirosm's avatar
rafaeloureirosm
Icon for Advocate I rankAdvocate I
9 years ago

= "Text" & Number.ToText(Number)

  • joopiest's avatar
    joopiest
    Frequent Visitor
    9 years ago

    Wow, That's pretty easy. 

    Thanks