Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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"]
User | Count |
---|---|
19 | |
10 | |
10 | |
9 | |
7 |