Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

CONCATENATEX - but exclude certain terms

Hello all,   I have a list of items that I need to present in a single cell on a table which are currently stored in individual lists, this is not a problem as I can use something like:    Item...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    I've alterered the columns that this draws from now (by making a conditional column that does what I wanted the filter to do) so this works with my original code. 

     

    Thanks for your suggestion though!

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

Anonymous , You can use

 

CONCATENATEX (
CALCULATETABLE (
VALUES ( Sheet1[Items] ),
ALLEXCEPT ( Sheet1, Sheet1[id]), filter (Sheet1, Sheet1[Col] ="Q")
),
[Items], ", "
)

 

or

 

 

calculate(
CONCATENATEX (
VALUES ( Sheet1[Items] ),
[Items], ", "
) , ALLEXCEPT ( Sheet1, Sheet1[id]), filter (Sheet1, Sheet1[Col] ="Q") )

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I've alterered the columns that this draws from now (by making a conditional column that does what I wanted the filter to do) so this works with my original code. 

     

    Thanks for your suggestion though!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks - that raises a circular dependancy issue, I'll look into it.