Forum Discussion
Look up value Column in DirectQuery Mode
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 'I...
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.