Retrieve last N records from a table

[Aylas]

Good morning, I have a table with multiple records, from which I want to retrieve the last N records, these in turn must belong to the same point.

IdReg__|Cod.Punto|pH__|Od|NTU …
2210|PTO001__|7.45|5.41|12.1
2211|PTO002_|8.15|7.97|7.88
2212|PTO003_|7.54|6.11|9.12
2213|PTO001_|6.78|4.18|7.45
2214|PTO002_|8.24|7.91|4.66
2215|PTO003_|9.11|7.48|9.44
2216|PTO001_|4.47|4.91|8.12
2217|PTO002_|6.54|6.88|10.4
2218|PTO003_|6.45|5.41|12.4
2219|PTO001_|4.47|4.91|8.12
2220|PTO002_|6.54|6.88|10.4
2221|PTO003_|6.45|_5.41|___12.4

What would be the method to obtain the last 10 records of the table that correspond to “PTO001”?

[Aurelien]

Hi @Aylas

Welcome to the community !

It will be a mix with TOP and ORDERBY.
Depending on your table structure, you may want to use a SELECT or FILTER as well.
For reference:

help.appsheet.com

ORDERBY()

Sort row references

help.appsheet.com

TOP()

Initial list items

[Aylas]

Thanks for the answer, could you give me a suggestion on how to use the mentioned expressions?

[Aurelien]

Yes.

Does that gives you a clue ?

Top select orderby Questions

I’m using this expression to find the Top 4 rows of the Overstock table to show in another table. TOP( SELECT(Overstock[Location and Box Qty],([_THISROW].[Product]=[Product Code on Overstock])) ,4) That works, but I need to order the list by a different column, Date Received, before showing the top 4. When I add ORDERBY it doesn’t work, I think because the list I want isn’t the key of the Overstock table. Is there a way I can do this?

or

SELECT with filter and order by Questions

I believe it may need to be done in 2 steps. TOP 2 ROWS : Find the two largest row numbers having the described criteria, Say this list type column is called [Top 2] with following expression something like below TOP(SORT( SELECT( Batch Details[_RowNumber], AND([Batch ID]=[_THISROW].[Batch ID], [Code]=[_THISROW].[Code], [Offer]=[_THISROW].[Offer])), TRUE),2) VC 2 SUMQuatities : Then find the qunatities with these two largest rownumbers and add these in another VC SUM(SELECT(Batch Details[Qua…

Otherwise, please share your table structure (with screenshot)

[Aylas]

I want to do the filtering through “Cod. Estación”, the primary key is “N° Muestra”

[Aurelien]

Thanks for the screenshot.

What about that ?

TOP(
  ORDERBY(
    FILTER("Registro CAR",
      [Cod. Estación]="CA-07"
    ),
  [_ROWNUMBER],true)
  ,10
)

Edit: some comma removed

[Aylas]

Thank you very much, for your consideration, I attach some screenshots, I did not manage to make the sentence run.

[Aurelien · Accepted solution]

Wait, you are on a row filter condition.
The expression was for giving a list of items, depending on a specific row.

From what I see, this would rather be:

IN([_THISROW],
TOP(
  ORDERBY(
    FILTER("Registro CAR",
      [Cod. Estación]="CA-07"
    ),
  [_ROWNUMBER],true)
  ,10
)
)

[Aylas]

Perfect, thank you very much, it worked like a charm.

[Steve]

There is an example of this in the TOP() help document.

[Aurelien]

Thank you @Steve for highlighting this.

I assumed it was not fitting enough to @Aylas 's case so I took time to make it fit.