CONCATENATE three column text values, but return blank if any of the three are blank

[SPa]

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!

[Anonymous]

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

[bsheffer · Accepted solution]

=if(<text1> = blank() || <text2> = blank() || <text3> = blank(),
"",

CONCATENATE (CONCATENATE (<text1>, <text2>), <text3>)

)