Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
Solved! Go to Solution.
Try this
coef = CALCULATE ( FIRSTNONBLANK ( Table2[Coef], 1 ), FILTER ( Table2, Table2[group1] = Table1[group1] && Table2[group2] = Table1[group2] ) )
Try this
coef = CALCULATE ( FIRSTNONBLANK ( Table2[Coef], 1 ), FILTER ( Table2, Table2[group1] = Table1[group1] && Table2[group2] = Table1[group2] ) )
It works well, but just wonder why the lookupvalue function dosen't work?
I had the same problem, thank so much
LookupValue should also work. Try this
coef = LOOKUPVALUE ( Table2[coef], Table2[group1], Table1[group1], Table2[group2], Table1[group2] )