Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

CONCATENATE EXCEPT BLANK VALUES

Hello everyone,   I have the following code, in which I am creating a new column with the purpose of creating combinations of articles according to the sessionId. However, some of the 'Articles' ro...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try like

     

    Combinations of Articles = ADDCOLUMNS(VALUES('Table1'[sessionId]), "Combinations of Articles", CALCULATE(CONCATENATEX(VALUES('Table1'[Articles]),'Table1'[Articles], "&"), filter('TABLE1', not(isblank('Table1'[Articles])))))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Try like

 

Combinations of Articles = ADDCOLUMNS(VALUES('Table1'[sessionId]), "Combinations of Articles", CALCULATE(CONCATENATEX(VALUES('Table1'[Articles]),'Table1'[Articles], "&"), filter('TABLE1', not(isblank('Table1'[Articles])))))