Trouble with simple DAX MAX for a group formula

[cblanton45]

I am trying to get this simple formula to calculate a Max based off of another column:

WellMax = CALCULATE(MAX([Depth],FILTER(Table,[Well]=EARLIER([Well]))))

When I get to the EARLIER function, it does not show the list of columns to select from so I am just typing it in.

When I resolve the formula I get the following message:

The value for 'Depth' cannot be determined. Either 'Depth' doesn't exist, or there is no current row for a column named 'Depth'

This is a calculated column, btw.

[cblanton45]

Seems to be working fine now.  I tried again later and just typed the formula from scratch and it allowed me to select from columns when I got to EARLIER.  Thanks

[v-cherch-msft · Accepted solution]

Hi @cblanton45 

Based on my test, it seems correct.Could you show us the sample data or the screenshot?

Regards,

Cherie