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?

 

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

     

2 Replies

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