Concatenate string & column

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

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 Billing Date", each List.Max(#"Last BillingDate"[Last Billing Date]))

This is adding the latest billing date in all rows in my new column. Perfect.

But what I really would like to do is adding also a small text before the date. So I tried the following:

Table.AddColumn(#"Removed Duplicates", "Last Billing Date", each "Last Billing Date=" & List.Max(#"Last BillingDate"[Last Billing Date]))

But this does not work.

I'm able to get what I want by adding some additionnal steps so I'm not in a hurry. But I'm wondering if there is any syntax which would give the same result in only one step.

Thanks for your advices