Forum Discussion
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...
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])))
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])))
Good point, I did not even think about converting the date into text.
Thanks a lot. Query is much more simple now.