Load Max(Date)

[Anonymous]

Hi,

how can I load the 7 maximum dates in my table as 'n seperate field? My script expression currently looks as follows but I'm getting an error when reloading:

[Dates]:

LOAD [Sales Date],

          Max([Sales Date],7) as [Sales Date7]

Resident [Sales table];

I appreciate your response.