Forum Discussion
Solved
Lookup 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 erro...
nok Try:
Column = VAR __ID = [ID] VAR __Result = MAXX( FILTER( 'Table1', [ID] = __ID ), [Summary] ) RETURN __Result
nok Try:
Column =
VAR __ID = [ID]
VAR __Result = MAXX( FILTER( 'Table1', [ID] = __ID ), [Summary] )
RETURN
__Result