Error using FINDLASTROW()

Community Discussions
, ,
1

Hi folks,

I attempted to follow the example in this post Filter based on highest value of another table which seemed like it'd help me solve a similar problem.

I keep getting "Formula contains a value that conflicts with its function or operator" when adding the formula to a column.

I even tried to replicate the same example as shown, still got the error.

I'm using this formula: =FINDLASTROW(XPhraseTable,"XPhraseTable[Code]=THISROW() ORDER BY XPhraseTable[EffectiveDate] ASC")[EffectiveStatus]

Any obvious errors in syntax or faux pas in using this formula? I even checked in my code editor for oddballs like hidden tab, line return, etc.

3

Hi @DevC-79e7,

Thank you for your question! I answered this in more detail in your previous post, but this formula should resolve the issue:

=FINDLASTROW(XPhraseTable,"XPhraseTable[Code]=THISROW()[Code] ORDER BY XPhraseTable[EffectiveDate] ASC")[EffectiveStatus]

Thank you,
Evelyn