I need to select the first 100 items from a list generated from several SELECT lists added.
LIST((SELECT(Destinatarios Fijos[_RowNumber],true)+
SELECT(Destinatarios Importados 1[_RowNumber],true)+
SELECT(Destinatarios Importados 2[_RowNumber],true)+
SELECT(Destinatarios Importados 3[_RowNumber],true)+
SELECT(Destinatarios Importados 4[_RowNumber],true))-
SPLIT(SELECT(Envรญos[Destinatarios],[Campaรฑa Id]=[_THISROW].[Campaรฑa Id])))
I understand that I must do it with FILTER () and with INDEX () but I canโt find a way.
Any guidance?
User | Count |
---|---|
17 | |
11 | |
6 | |
5 | |
5 |