Forum Discussion

bharka's avatar
bharka
Regular Visitor
8 years ago
Solved

lookupvalue filtering 2 columns

Hi,   sorry if this problem was already solved here, i was trying to find it but none of the solutions i found helped (but i'm a beginner).   I have two tables:  i need to get the pass...
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    bharka

     

    Try this

     

    coef =
CALCULATE (
    FIRSTNONBLANK ( Table2[Coef], 1 ),
    FILTER (
        Table2,
        Table2[group1] = Table1[group1]
            && Table2[group2] = Table1[group2]
    )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

bharka

 

LookupValue should also work. Try this

 

coef =
LOOKUPVALUE (
    Table2[coef],
    Table2[group1], Table1[group1],
    Table2[group2], Table1[group2]
)