CONCATENATEX and leading delimiter

[Anonymous]

Hi again, 

I've solved one problem today, but hit another - so my code:

Itemlist =
CONCATENATEX (
CALCULATETABLE (
VALUES ( Sheet1[Items] ),
ALLEXCEPT ( Sheet1, Sheet1[id])
),
[Items], ",  " , [Items]
)

Produces a list of items, sorted nicely, etc - however, each list is starting with a ',':

e.g.

", apple, cheese, orange" 

there are some null values in the items list, but replacing these with a blank doesn't fix the problem, should I be checking with ISBLANK or similar?

Thanks again! 

[CNENFRNL · Accepted solution]

Itemlist =
CONCATENATEX(
    CALCULATETABLE(
        VALUES( Sheet1[Items] ),
        ALLEXCEPT( Sheet1, Sheet1[id] ),
        NOT ISBLANK( Sheet1[Items] )
    ),
    [Items],
    ",  "
)

[Anonymous]

Perfect - thank you

[Anonymous]

Before you start building the string, filter out the values you don't want.