How to remove duplicate rows leaving only the last row added(using slice)

Hi everyone!
This app is made for flower industry
Not sure what is the best way to achieve my goal…
a little contextualization:

Variedad= flower type
Cama= Bed–>where the flowers are planted ( one flower type per bed)
Bloque= Group of beds (in one “bloque” can be planted diferent type of flowers)
Fecha estimado=Date when the person did the estimate

when a flower type is near to be cutted because is ready, a person stands next to the bed and estimates the amount of flowers that they can get from that specific bed.
this process can be done up to 10 times and in everytime the person can estimate a differente amount.
that´s why i need only the last estimate record of that especific bed.

then when i have the information filtered(without the duplicates , only the information with the recent estimation date ) i need to show the type of flower (variedad) and group of beds(bloque) in a calendar.

Thank you very much!

Is this the row with the latest Fecha estimado for its particular Variedad, Bloque, Cama combination?

ISBLANK(
  FILTER(
    "table",
    AND(
      ([Variedad] = [_THISROW].[Variedad]),
      ([Bloque] = [_THISROW].[Bloque]),
      ([Cama] = [_THISROW].[Cama]),
      ([Fecha estimado] > [_THISROW].[Fecha estimado]),
    )
  )
)

replacing table with the name of the table.

2 Likes

Thank you Steve !
it works :smiley: :smiley:

1 Like