Need Help With Calculated Column

[mjanecek]

I have a dimension table called Markets that has 2 columns, Market Name(Market) and Market ID.

I wish to add a column that precedes the market id with 2 random integers and postcedes the market id with 2 random integers.

I have written the below Dax.

Market Mask =

var mkt = Markets[Market ID]

var randb4 =  RANDBETWEEN(50,99)

var randafter = RANDBETWEEN(50,99)

return  mkt

I'm retruning the market id by itself with no issue.

When I try to concantenate the random numbers to the returun expression, the return expression goes to a boolean value.

Market Mask =

var mkt = Markets[Market ID]

var randb4 =  RANDBETWEEN(50,99)

var randafter = RANDBETWEEN(50,99)

return  randb4 && mkt

I tried converting each expression to a string and the result is still the same.

Market Mask =

var mkt = Markets[Market ID]

var randb4 =  RANDBETWEEN(50,99)

var randafter = RANDBETWEEN(50,99)

return  convert(randb4,STRING) && convert(mkt,STRING)

My expressions for random numbers work fine without any concantenation also.

Market Mask =

var mkt = Markets[Market ID]

var randb4 =  RANDBETWEEN(50,99)

var randafter = RANDBETWEEN(50,99)

return randb4

How can I concantenate the 3 variables in my code together into one expression?

[Daniel29195 · Accepted solution]

@mjanecek 

try using concatenate function 

If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that  thumbs up button 🫡👍