hi

[abc_777]

hi

very simple query

how i can concatante a word with a column

i go to customer column then

"quarter"&""&[Quarter Of Year]

here quarter is my given word and Quarter of year is column name i want all values in quarter of year for quarter word in front

thanks

[Greg_Deckler]

@abc_777 That is the correct syntax for a DAX calculated column. "quarter" & [Quarter of Year]. You could use the CONCATENATE function as well but don't see why that is necessary. 

[abc_777]

but

"quarter"&""&[Quarter Of Year] gives me error in column

i have only 1,2,3,4 values in [Quarter Of Year] column. so i dont know why getting error

[SanketBhagwat]

Can you specify what error you are getting?

I see you haven't specified any delimeter in your DAX.
USe the same DAX and specify a space(" ") as an delimeter. 
"quarter"&" "&[Quarter Of Year] 

Thanks,
Sanket

[abc_777]

hi

here is my column

after creating customer column

i am getting this error

[SanketBhagwat]

That's right.
It's because you can't apply operator '&' to number.

In that case, you can create a calculated column.

Thanks,
Sanket

[abc_777]

in that case creating calculated column what would be the formula to concatanate word with a column

[SanketBhagwat · Accepted solution]

Concat=COMBINEVALUES(" ","quarter",[Quarter Of Year])

[SanketBhagwat]

Hi @abc_777 .

You can create a new column using DAX like;
Concat=COMBINEVALUES(" ","quarter",[Quarter Of Year])

Let me know if that works.

If this post helps, then mark it as "Accept as Solution" and give it a thumbs up.

Regards,
Sanket