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.
Hello,
I have two tables in Direct Query mode related via a Many to One relationship (Please see below). I would like to find the value within column 'MinMax' column from Table 1 in the column 'Id' in Table 2 and retrieve the value within column 'Higher' of Table 2.
If I use the expression below just for a single valuer from MinMax column of table 1, it works:
Test = LOOKUPVALUE(Table 2['Higher'], Table 2['Id'],143)
However I don't know how I could modify the expression above to do all values within MinMax column of Table1.
Any help would be really appreciated!
thanks!
HI @LauraBueno,
AFAIK, current power bi has limited most of Dax functions usage in calculated column/table if you are work with 'direct query' mode. I'd like to suggest you use measure expression instead.
To extract the current row content, you can try to use aggregate function min/max or selectedvalue functions.
Regards,
Xiaoxin Sheng
You cannot use LOOKUPVALUE() as it cannot handle your M:M ambiguity (it can only return a scalar value, not a table). Use TREATAS() instead.
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 |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |