Lookup unique values in table by date

[Edmundas]

Hi there,

I have table and need to write formula in Column2 where Column1 values would be lookuped up by date. Any help please?

[Greg_Deckler · Accepted solution]

@Edmundas Maybe:

Column2 =
  VAR __Date = [Date]
  VAR __Table = FILTER(ALL('Table'),[Date] = __Date)
RETURN
  MAXX(__Table,[Column1])

[Edmundas]

Thank you so much, it worked perfectly!