How to select 100 items from a list

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?

0 3 333
3 REPLIES 3

Will the TOP() function work?

Thank you very much I did not remember that this expression existed!

As you probably know, you typically use TOP in conjunction with SORT. SORT ensures that the records you want are at the โ€œtopโ€ of the list.

Top Labels in this Space