Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Calculated Multiple Lookup Values

HELP!  I've taken a new position that utilizes Power Bi heavily and I'm trying to run a new column (A that takes my 'Accessorials' column and references two other tables in order to populate all poss...
Need Help
Tutorial Requests
amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , I only got the part of more than one condition, so option is you can add more than one condition

 

Accesorial.Text = LOOKUPVALUE(AccessorialModeLTL[Attribute.Text], AccessorialModeLTL[Attribute.Value], '4-1 StoredProcedure Query'[Accessorials], <> , <> )

 

or you can try like

 

Accesorial.Text = maxx(filter( AccessorialModeLTL, AccessorialModeLTL[Attribute.Value], '4-1 StoredProcedure Query'[Accessorials]
&& AccessorialModeLTL[Col2 ], '4-1 StoredProcedure Query'[Col2]) ,AccessorialModeLTL[Attribute.Text])