Forum Discussion

LauraBueno's avatar
LauraBueno
Helper III
5 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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