Forum Discussion
o59393
Post Prodigy
Post ProdigyConcatenate Text with Measure not Custom Column
Hi all I am trying to concatenate 2 text columns with a dax measure, not with query editor's custom column. I used the dax Concat = CONCATENATE (
SELECTEDVALUE ( Query1[[L1.3 - Countr...
Hi,
This DAX formula works
Measure = CONCATENATEX(Data,Data[[L1.3 - Country]]]&" "&Data[[L1.8 - Bev Segment]]],UNICHAR(10))Hope this helps.
Or, if you just want a calculated column just do this:
Column =
CONCATENATE(Query1[[L1.3 - Country]]] & " ",Query1[[L1.8 - Bev Segment]]] )
o59393Post Prodigy
Post ProdigyHi Greg_Deckler
Almost ok! I see that all the values are in once cell, how can they be separated per row?
The expected result is this one in the excel.
https://1drv.ms/u/s!ApgeWwGTKtFdhj7fQfJwcIsMFfcw?e=osMaWm
Sorry for this, next time i will include the solution.
Thanks a lot.
Ashish_Mathur
Super User
Super UserHi,
This DAX formula works
Measure = CONCATENATEX(Data,Data[[L1.3 - Country]]]&" "&Data[[L1.8 - Bev Segment]]],UNICHAR(10))Hope this helps.