TextJoin with 2 criteria

[Dani_LobP]

Hi,

I am struggling to make Textjoin work with an additional criteria.

=TEXTJOIN(", ",TRUE,UNIQUE(FILTER(RawData[ID],RawData[Issue Status]="","")))

I am using the above code, which works, but then i want to use the same one, but adding an additional condition, which should be the below:

=IF(RawData[Aggregate status]="Open",TEXTJOIN(", ",TRUE,UNIQUE(FILTER(RawData[ID],RawData[Issue Status]="",""))),"")

Problem, i see.. is that apart from seeing #Spill! error, is that it should actually give empty result.

The idea is to obtain IDs from a table, where there is blank cell in specific columns.
And also, same as above, but when at the same time, the status is Open.

There is a table called RawData, and column names are as mentioned in the code. All i care is about the empty cells from the columns, and obtain the ID.

Hope it makes sense the explanation.

Thanks in advance!
Dani

 

[Fluff]

How about

=TEXTJOIN(", ",TRUE,UNIQUE(FILTER(RawData[ID],(RawData[Issue Status]="")*(RawData[Aggregate status]="Open"),"")))

 

[Dani_LobP]

How about

=TEXTJOIN(", ",TRUE,UNIQUE(FILTER(RawData[ID],(RawData[Issue Status]="")*(RawData[Aggregate status]="Open"),"")))

oh great! that works, thanks!

so if i add the * , its like adding criteria one after the other?

 

[Fluff]

The * is multiplying the 2 arrays so that both have to be true for a value to be returned. If you wanted to return values where one or the other was true you would use + instead.