Lookup values ​​from another table without LOOKUPVALUE function

[nok]

Is there any way to lookup values ​​from another table based on the most recent date, without using the LOOKUPVALUE function? I'm creating a calculated column and I'm getting ciruclar dependency error when I use the LOOKUPVALUE function.

This is the code that is giving me circular dependency:

LOOKUPVALUE(Table1[Summary], Table1[ID], MyTable[ID])

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result.  Share data in a format that can be pasted in an MS Excel file.

[Greg_Deckler · Accepted solution]

@nok Try:

Column = 
  VAR __ID = [ID]
  VAR __Result = MAXX( FILTER( 'Table1', [ID] = __ID ), [Summary] )
RETURN
  __Result