concatenate value with text

[AAbdelkader]

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

[ImkeF · Accepted solution]

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]"))