Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
PHDurand
Helper I
Helper I

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

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

6 REPLIES 6
PHDurand
Helper I
Helper I

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

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
Resident Rockstar
Resident Rockstar

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





Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



Anonymous
Not applicable

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

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

Thanks a lot. Query is much more simple now.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.