Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help with using the MAX function in a custom column

Hi,   I need to create a custom column using a DAX statement.  I'm pretty sure I need to use the MAX or MAXX function to accomplish what I'm trying to do here.   Specifically, I need the new colu...
Need Help
  • smpa01's avatar
    smpa01
    5 years ago
    Column 2 = IF([finish]=CALCULATE(MAX('Table'[finish]),ALLEXCEPT('Table','Table'[id])),[members])

    Anonymous  can you please try the above as a calculated column

    finish = MonthEnd

    id=GroupID

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymousplease provide the sample data here in a way which can be easily copy pasted