How do i filter using a max variable within a variable chain while creating a table

i have a formula that looks like this. This works and gives me date above 01,01,2022

Final Table = 

Var Table1=

"Pulled a table out of here

Var Table2 =

ADDCOLUMNS(Table1,"rank_order", RANKX(FILTER(Table1,[id]=EARLIER([id])),[date],,ASC,Dense))

var Table3 = 
FILTER(Table2,[date] >= DATE(2022,01,01))

return Table3

However I want to do something like this becasue I want to create a dynamic table outcome.

Var Table1=

"Pulled a table out of here

Var Table2 =

ADDCOLUMNS(Table1,"rank_order", RANKX(FILTER(Table1,[id]=EARLIER([id])),[date],,ASC,Dense))

var Table3 = 
FILTER(Table2,[date] >= DATE(MAX(Table2[date]),01,01))

return Table3

note before I had Date(2022,01,01), but I want Date(Max(table2[date]),01,01). However when I try to do it this way I get "Cannot identify the table that contains [date] column.