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

     

FreemanZ's avatar
FreemanZ
Super User
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
    )
)

 

Vtomsons's avatar
Vtomsons
Helper I
3 years ago

Perfect. It worked!

 

Thanks!