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 passing coefficients from the second table to the first one as a new column. Both group 1 and group 2 can be duplicate but the combinations of the groups are unique. The coefficients do not have to be unique. obviously i can't use LOOKUPVALUE and i'm kind of stuck here. Can anyone help me please?

  • 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]
    )
)

5 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    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]
)
    • Jonathas's avatar
      Jonathas
      Frequent Visitor
      7 years ago

      I had the same problem, thank so much

    • Jay_Lu's avatar
      Jay_Lu
      New Member
      3 years ago

      It works well, but just wonder why the lookupvalue function dosen't work?