Issue with Date function

[sshiny]

My data is filtered when I hardcode as shown below.

Table =

VAR DateStart = DATE("2022", "11", "1")
VAR DateEnd = DATE("2023", "1", "5")

RETURN

  CALCULATETABLE(

      'Recorded Orders Fact',

      FILTER('Recorded Orders Fact','Recorded Orders Fact'[Order Date] <= DateEnd && 'Recorded Orders Fact'[Order Date] >= DateStart)

  )

But, I am unable to get the filtered data when I was the function TODAY(), MAX or LASTDATE. Please help me find the DAX . The below code does not filter the data.

Table =

VAR DateStart = MAX('Recorded Orders Fact'[Order Date])

VAR DateEnd   = MAX('Recorded Orders Fact'[Order Date]) - 30

RETURN

  CALCULATETABLE(

      'Recorded Orders Fact',

      FILTER('Recorded Orders Fact','Recorded Orders Fact'[Order Date] <= DateEnd && 'Recorded Orders Fact'[Order Date] >= DateStart)

  )

[Mahesh0016]

@sshiny 
Table =

VAR DateStart = MAX('Recorded Orders Fact'[Order Date])

VAR DateEnd   = MAX('Recorded Orders Fact'[Order Date]) - 30

RETURN

  CALCULATETABLE(

      'Recorded Orders Fact',

      FILTER('Recorded Orders Fact','Recorded Orders Fact'[Order Date] <=DateStart  && 'Recorded Orders Fact'[Order Date] >=DateEnd )

  )

*If this post helps, please consider accept as solution to help other members find it more quickly and Appreciate your Kudos.

[amitchandak]

@sshiny , Change position of start and end , start should be smaller

VAR DateEnd = MAXX(allselected('Recorded Orders Fact'),'Recorded Orders Fact'[Order Date])
VAR DateStart = MAXX(allselected('Recorded Orders Fact'),'Recorded Orders Fact'[Order Date]) - 30

RETURN
CALCULATETABLE(
'Recorded Orders Fact',
FILTER('Recorded Orders Fact','Recorded Orders Fact'[Order Date] <= DateEnd && 'Recorded Orders Fact'[Order Date] >= DateStart)
)

If needed use allselected