Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I am trying to concatenante two columns in a table, with an underscore between them, without using merge(because I wish to retain the original two columns as well)
I've tried the CONCATENANTE command, AND "addColumn" to no avail, like below.
"Full Name MYNEWCOLUMNNAME= CONCATENATE(dbo_MYTABLENAME[MYFIELD#1]
&"_",dbo_MYTABLENAME[MYFIELD#2])"
and
= Table.AddColumn(dbo_MYTABLENAME, "MYNEWCOLUMNNAME", each Table.AddColumn(dbo_dbo_MYTABLENAME,
"MYFIELD#1", each [JAXLAWSONREQUISITIONNO]+"_"+[MYFIELD#2]))
Thoughts?
Thanks much,
Richj
Solved! Go to Solution.
Insert a custom column from Add Column menu and paste the below in the box
[#"MYFIELD#1"] & "_" & [#"MYFIELD#2"]
Insert a custom column from Add Column menu and paste the below in the box
[#"MYFIELD#1"] & "_" & [#"MYFIELD#2"]