Forum Discussion
Concatenate string & column
- Anonymous8 years ago
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])))
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
OK, will move my post there then.
Thanks