Forum Discussion

AAbdelkader's avatar
AAbdelkader
Icon for Helper I rankHelper I
9 years ago
Solved

concatenate value with text

Hello there,

 

please I need help in concatenation a value with a text, as I used that formula to concatenate the row values in [Spent time] column

 

= Table.AddColumn(#"Inserted Year", "Custom", each CONCATENATE([Spent Time], " Year[s]"))

 

then add to each one the string " Year[s]". but always face that error 

 

Expression.Error: The name 'CONCATENATE' wasn't recognized.  Make sure it's spelled correctly.

 

is there something should iI take in consideration.

 

thanks a lot

Show and Tell
  • ImkeF's avatar
    ImkeF
    9 years ago

    Hi, you're in the query-editor here, where you need to use M and not DAX.

     

    Just write it like so:

    = Table.AddColumn(#"Inserted Year", "Custom", each Text.From([Spent Time]) & ", Year[s]"))

1 Reply

  • ImkeF's avatar
    ImkeF
    Icon for Community Champion rankCommunity Champion
    9 years ago

    Hi, you're in the query-editor here, where you need to use M and not DAX.

     

    Just write it like so:

    = Table.AddColumn(#"Inserted Year", "Custom", each Text.From([Spent Time]) & ", Year[s]"))