Forum Discussion

AAbdelkader's avatar
AAbdelkader
Helper 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",...
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]"))
ImkeF's avatar
ImkeF
Community 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]"))