Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to Solution.
Hi, Richard. @cottrera
The quickest way to do this is using the ampersand & character. Like this,
Column D = [column a] & " - " & [column b] & " - " & [column c]
Hi, Richard. @cottrera
The quickest way to do this is using the ampersand & character. Like this,
Column D = [column a] & " - " & [column b] & " - " & [column c]
ésto me funciono realmente, Muchas Gracias
The proposed solution worked well in 2019 and for just three columns but in case anyone stumbles across this now, I would like to point out there is a better way that probably wasn't available in 2019
The DAX "COMBINEVALUES" function joins text using a delimiter.
COMBINEVALUES("-",Column1, Column2, Column2)
and this can be used for many more columns as well
Note that the delimiter cannot be a blank or empty string so if you don't want to join your values with a delimiter, then just use one that will definitely not be in the columns and then substitute it afterwards (e.g. "~" or similar).
SUBSTITUTE(
COMBINEVALUES("~",
Column1,
Column2,
Column3
),
"~",""
)
Fantastic. Reading in 2023, none of the above solved my issue (trying to Concat 3 columns when in DirectQuery), but this function did. Thank you!
Works perfect thank you for the quick reponse
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |