Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
All I did was to create a new column
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.
@Anonymous
You can also do the concatenation by “Merge Columns” in Query Editor. Select these two columns and click “Merge Columns”.
Best Regards,
Herbert
= "Text" & Number.ToText(Number)
Wow, That's pretty easy.
Thanks
@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
This should be the solution, because the request was to use DAX, not Power Query M.
Thanks, ended up using Text.From( [Counter] )
Format() is the correct answer. What you've used is not DAX
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"
Not sure I'm fully understanding you @Anonymous
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.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |