Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Return value from another column

I'm using lastnonblank to find a value in a table (all case statuses), but want to bring back the value in a different column in that same row.   The formula is   Year End Status = CALCULATE(    M...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    That worked, but I need to return two values (from separate columns).   If I try to do two columns using the lookup function, I get an error indicating circular dependency.

     

    The formula for the current calculated column that does the lookup is:

     

    Year End Status = LOOKUPVALUE('All Case Statuses'[CaseStatusDescription]
        ,'All Case Statuses'[StatusID],(CALCULATE(
        MAX('All Case Statuses'[StatusID]),
        FILTER(FILTER('All Case Statuses','All Case Statuses'[CaseStatusYear] <= 'Base Case Expanded'[YearEnd]),
        LASTNONBLANK('All Case Statuses'[StatusID],MAX('All Case Statuses'[StatusID])))))

     

    This brings back the Case Status Description from the All Case Statuses table, but I also want to bring back another value (and upt in a differect column) based on the same search value.