Concatenate string & column

[PHDurand]

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

[PHDurand]

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

[PHDurand]

OK, will move my post there then.

Thanks

[DanDay]

Hi PHDurand

Requests for help should be posted in the relevent section here: https://community.powerbi.com/t5/Forums/ct-p/Forums

This is the error reporting forum so won;t have many people looking to help.

Regards,

Dan

[ChrisMendoza]

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

[Anonymous · Accepted solution]

@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]

Good point, I did not even think about converting the date into text.

Thanks a lot. Query is much more simple now.