Forum Discussion

abc_777's avatar
abc_777
Solution Specialist
4 years ago
Solved

hi

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

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

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

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    4 years ago

    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's avatar
      abc_777
      Solution Specialist
      4 years ago

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        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