Forum Discussion
Post ProdigyConcatenate Text with Measure not Custom Column
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]]] )
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.
Community Championo59393 - So like this?
Concat =
VAR __Table =
ADDCOLUMNS(
'Query1',
"__Concat",CONCATENATE(Query1[[L1.3 - Country]]] & " ",Query1[[L1.8 - Bev Segment]]] )
)
RETURN
CONCATENATEX(__Table,[__Concat],UNICHAR(10))- Greg_Deckler
o59393 - If you want it like the Excel file, that was the first solution (with the MAX values) and you add that measure to your table visualization. You don't want a separate visualization in that case. Or am I missing something?
See the attached file with both of the possible solutions.
- Greg_Deckler
Or, if you just want a calculated column just do this:
Column =
CONCATENATE(Query1[[L1.3 - Country]]] & " ",Query1[[L1.8 - Bev Segment]]] )