Forum Discussion

nok's avatar
nok
Advocate II
1 year ago
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...
Data Protection
Need Help
Tips and Tricks
Tutorial Requests
  • Greg_Deckler's avatar
    Greg_Deckler
    1 year ago

    nok Try:

    Column = 
  VAR __ID = [ID]
  VAR __Result = MAXX( FILTER( 'Table1', [ID] = __ID ), [Summary] )
RETURN
  __Result
Ashish_Mathur's avatar
Ashish_Mathur
Super User
1 year ago

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.