Forum Discussion
nok
Advocate II
Advocate IILookup values from another table without LOOKUPVALUE function
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])
nok Try:
Column = VAR __ID = [ID] VAR __Result = MAXX( FILTER( 'Table1', [ID] = __ID ), [Summary] ) RETURN __Result
2 Replies
- Greg_Deckler
Community Champion
nok Try:
Column = VAR __ID = [ID] VAR __Result = MAXX( FILTER( 'Table1', [ID] = __ID ), [Summary] ) RETURN __Result - Ashish_Mathur
Super User
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.
