DAX to retrieve value from another column based on a condition

[Anonymous]

Hi Community,

I need help in writing a DAX for retrieving a value from another coumn based on a condition.

For example in the following dataset, for P_id =3, I want to compare the corresponding addres_id (567) with any existing address ids, if a match is found populate address column with its corresponding address(in this case populate 'FGH')

Many thanks in advance,

Meena

[camargos88 · Accepted solution]

Hi @Anonymous ,

try this code for a calculated column:

Column =

VAR _address_id = 'Table'[Address_id]

RETURN CALCULATE(DISTINCT('Table'[Address]), FILTER('Table', 'Table'[Address_id] = _address_id && 'Table'[Address] <> BLANK()))

OR

Column =

VAR _address_id = 'Table'[Address_id]

RETURN CALCULATE(MAX('Table'[Address]), FILTER('Table', 'Table'[Address_id] = _address_id))