Forum Discussion

Vtomsons's avatar
Vtomsons
Helper I
3 years ago
Solved

MAX Function only accepts a column reference as an argument

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?   Las...
Need Help
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    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
        )
    )