MAX Function only accepts a column reference as an argument

[Vtomsons]

Hi,

I have used this equation before but this time I can't get rid of the error(MAX Function only accepts a column reference as an argument). Does anyone see why I am getti ng the error?

Last No Extension Date Qty =

    var _max = MAXX(FILTER(ALLSELECTED('Combined Reg''n'), 'Combined Reg''n'[Student ID] = MAX('Combined Reg''n'[Student ID])), 'Combined Reg''n'[Registration start date])

    return CALCULATE(SUM('Combined Reg''n'[No Extension Revenue]),FILTER('Combined Reg''n','Combined Reg''n'[Student ID]=MAX('Combined Reg''n'[Student ID] && 'Combined Reg''n'[Registration start date] = _max)))

[FreemanZ · Accepted solution]

hi @Vtomsons

 try like:

Last No Extension Date Qty =

var _max = 

MAXX(

    FILTER(

        ALLSELECTED('Combined Reg''n'), 

        'Combined Reg''n'[Student ID] = MAX('Combined Reg''n'[Student ID])

    ), 

    'Combined Reg''n'[Registration start date]

)

return 

CALCULATE(

    SUM('Combined Reg''n'[No Extension Revenue]),

    FILTER(

        'Combined Reg''n',

        'Combined Reg''n'[Student ID]=MAX('Combined Reg''n'[Student ID]) 

            && 'Combined Reg''n'[Registration start date] = _max

    )

)

[Vtomsons]

Perfect. It worked!

Thanks!