topic Re: Calculated Column to return value from other table with condition in DAX Commands and Tips

Calculated Column to return value from other table with condition

Anonymous — Fri, 06 Sep 2019 02:04:37 GMT

Table 1

Table 2

Create a calculated column in Table 1 to bring in the value from Table2 where Author = "John"

Expected result

DAX expression? I have the model with direct query so cant use LOOKUPVALUE function.

Please help...Appreciate your help...Thank you

Greg_Deckler — Fri, 06 Sep 2019 02:16:30 GMT

Well, probably could do something like:

Column = 
VAR __id = [ID]
RETURN
MAXX(FILTER(ALL('Table 2'),'Table 2'[ID] = __id && [Author] = "John"),[Area])

Something like that...

Anonymous — Mon, 09 Sep 2019 16:02:08 GMT

Thank you Greg for the solution. As our requirement slightly changed, we ened up creating a measure that returns the same value.

Appreciate you help..