Forum Discussion

PHDurand's avatar
PHDurand
Helper I
8 years ago
Solved

Concatenate string & column

Hi all, I need help to concatenate some data. I want to add the max value from another table in a Costumed column. This step works fine as below: Table.AddColumn(#"Removed Duplicates", "Last Billi...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    PHDurand,

    You can use Text.From function to covert your billing date to text for concatenation

    Table.AddColumn(#"Removed Duplicates", "Last Billing Date", each "Last Billing Date=" & Text.From(List.Max(#"Last BillingDate"[Last Billing Date])))
ChrisMendoza's avatar
ChrisMendoza
Resident Rockstar
8 years ago

PHDurand,

 

Same result as Anonymous by using Text.Combine ( ):

 

= Table.AddColumn(#"Changed Type", "Custom", each Text.Combine({"Last Billing Date", Text.From(List.Max(#"Changed Type"[Date]))}, " "))