Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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] )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
105 | |
78 | |
68 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
84 | |
70 |