Forum Discussion

mscantle's avatar
mscantle
Icon for Helper I rankHelper I
2 years ago
Solved

Lookup value in another table using multiple criteria, including a fixed value

Hi all,   I have one table that looks like this: And another table like this:   The two tables are related via Idno. I want to create a column in the first table that shows the Engl...
Need Help
  • Joe_Barry's avatar
    Joe_Barry
    2 years ago

    Hi mscantle 

    I adapted the measure as i forgot the date

    I just tested and it works for me

     

    Please try again

    English Grade = 
CALCULATE (
    SUM('Table1'[Grade]), 
    FILTER (
        'Table1',
        'Table1'[Idno] = 'Table2'[Idno]
        && 'Table1'[Date] = 'Table2'[Date]
        && 'Table1'[Subject] = "English"))

     

mscantle's avatar
mscantle
Icon for Helper I rankHelper I
2 years ago

That's fantastic - many thanks Joe!