bring last value recorded in the reading table

[DEVIMPLOY_Autom]

Hello . I need help with a formula.

In the Reading form
as soon as I choose the Machine
he bring me to
Previous Entry and most recent Previous Exit.

Otherwise , it will bring the Current Input and Current Output values .

@Steve  can you help me ?

[TeeSee1]

If I understand you correctly you can try

INDEX(
 SELECT(
  Lucky Machine[target column here],
  [key column of Lucky Machine] 
  = 
  MAXROW(
   "Lucky Machine",
   "_ROWNUMBER",
   [IDMaquina_Eliura] = [_THISROW].[IDMaquina_Eliura]
  )
 ),
 1
)

in the Initial Value of each of the columns (adopt the [target column here] to each column)

[DEVIMPLOY_Autom]

hi , i used this expression ... thanks for your help!😀

if(
isblank(
any(
     SELECT(Leitura[EntradaAtual],[IDleitura]=
              MAXROW("Leitura","EntradaAtual",[IDmaquinaLeitura]=[_THISROW].[IDmaquinaLeitura])))),

[IDmaquinaLeitura].[EntradaAtual],

any(
      SELECT(Leitura[EntradaAtual],[IDleitura]=
          MAXROW("Leitura","EntradaAtual",[IDmaquinaLeitura]=[_THISROW].                                [IDmaquinaLeitura]))))