Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all!
Need to create a new column that combines the text from three columns (same table)
Example Data (Column 1-3 are in the same table)
Column 1 Column 2 Column 3 Desired Column
'Text ZZZ' 'Text XXX' 'Text CCC' 'Text ZZZ Text XXX Text CCC'
'Text XXX' 'Text CCC'
'Text ZZZ' 'Text XXX'
'Text ZZZ' 'Text CCC'
'Text ABC' 'Text ABC' 'Text ABC' 'Text ABC Text ABC Text ABC'
Is there dax code to achieve this for a new column?
Thanks in advance for your help!
Solved! Go to Solution.
=if(<text1> = blank() || <text2> = blank() || <text3> = blank(),
"",
CONCATENATE (CONCATENATE (<text1>, <text2>), <text3>)
)
I think he wants to concatenate only if all 3 cells are not empty, you could use if:
IF(
column1<>"", IF(
column2<>"",IF
(column1<>"",CONCATENATE (CONCATENATE (<text1>, <text2>), <text3>))))
something of similar, you have to fix the brackets,
Best.
GV
=if(<text1> = blank() || <text2> = blank() || <text3> = blank(),
"",
CONCATENATE (CONCATENATE (<text1>, <text2>), <text3>)
)
User | Count |
---|---|
94 | |
86 | |
78 | |
70 | |
63 |
User | Count |
---|---|
114 | |
99 | |
97 | |
65 | |
59 |