Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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
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
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]))}, " "))
Proud to be a Super User!
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.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |