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
7 years ago

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.