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])))
PHDurand's avatar
PHDurand
Helper I
8 years ago

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