https://community.fabric.microsoft.com/t5/Developer/LOOKUPVALUE/m-p/636205#M18681 <P>LOOKUPVALUE can have multiple searches<BR /><A href="https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax" target="_blank">https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax</A><BR /><BR /></P> <P>&nbsp;</P> <P>you can do the following<BR /><SPAN></SPAN></P> <PRE>OLDPC = LOOKUPVALUE(PCS[ComputerName], PCS[Email], USERS[Email], PCS[Status], "OLD")&nbsp;&nbsp;</PRE> <P>&nbsp;</P> Mon, 04 Mar 2019 11:50:40 GMT Stachu 2019-03-04T11:50:40Z https://community.fabric.microsoft.com/t5/Developer/LOOKUPVALUE/m-p/616005#M18474 <P>I am looking to do a LOOKUPVALUE but this a where clause.&nbsp;</P><P>&nbsp;</P><P>I have 2 tables.&nbsp;&nbsp;</P><P>&nbsp;</P><P>I want to look up the old pc name&nbsp;</P><P>&nbsp;</P><P>PCS</P><P>EMAIL|ComputerName|Status</P><P>&nbsp;</P><P>USERS</P><P>USERNAME|Email</P><P>&nbsp;</P><P>So this lookup works fine</P><P>&nbsp;</P><DIV><DIV><SPAN>OLDPC = LOOKUPVALUE(PCS[ComputerName], PCS[Email], USERS[Email])&nbsp;&nbsp;</SPAN></DIV><DIV><SPAN>But i only want to show where the status value is OLD.</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>What would the syntax be for this where part?&nbsp; if there is such a thing</SPAN></DIV></DIV> Mon, 04 Feb 2019 11:28:09 GMT https://community.fabric.microsoft.com/t5/Developer/LOOKUPVALUE/m-p/616005#M18474 Wecks 2019-02-04T11:28:09Z https://community.fabric.microsoft.com/t5/Developer/LOOKUPVALUE/m-p/636205#M18681 <P>LOOKUPVALUE can have multiple searches<BR /><A href="https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax" target="_blank">https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax</A><BR /><BR /></P> <P>&nbsp;</P> <P>you can do the following<BR /><SPAN></SPAN></P> <PRE>OLDPC = LOOKUPVALUE(PCS[ComputerName], PCS[Email], USERS[Email], PCS[Status], "OLD")&nbsp;&nbsp;</PRE> <P>&nbsp;</P> Mon, 04 Mar 2019 11:50:40 GMT https://community.fabric.microsoft.com/t5/Developer/LOOKUPVALUE/m-p/636205#M18681 Stachu 2019-03-04T11:50:40Z