Concat more than 3 columns returns the Delimiter

[RanjanThammaiah]

Hi All,

I have used the below DAX to concat the columns. But the problem is with the Delimiter where there is no string in the columns it returns the Delimiter. which I don't want to see. Is there any way to get rid of this?

Thanks,

Ranjan

[Greg_Deckler]

@RanjanThammaiah UNION your columns together and FILTER for non BLANK values and then use CONCATENATEX.

[RanjanThammaiah]

Thanks @Greg_Deckler , The data size is very huge. if I union the columns. does it impact the Numbers?

[Greg_Deckler]

@RanjanThammaiah I wouldn't think it would excessively impact the creation of the column. Would certainly be faster I would think rather than individually checking if each column is BLANK for example. And sorry, use a table constructor, not UNION, see below.

Column = 
    CONCATENATEX(
        FILTER(
            { [7. Keyword Tag -1], [7. Keyword Tag -2], [7. Keyword Tag -3], [7. Keyword Tag -4], [7. Keyword Tag -5]},
            [Value] <> BLANK()
        ),
        [Value],
        ","
    )