Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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] )
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
68 |