Extract the last value of a list

[Tiago_Pereira]

Hi there

I need some help please i have two tables one with records of visits at the same client or different and another table with customer information ( phone, name, email,stock).

i need to extract the last information of the stock of the first table and show in the second table corresponding the company_id

I already made this formula so that it gives me the first registration of the stock and I want the last

LOOKUP([_THISROW].[Company_ID],“Contactos equipa Pisca”,“ID do Pisca”,“Stock na empresa”)

Can you help? please