topic Re: Loopupvalue in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Loopupvalue/m-p/3050214#M105033 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="506514" data-lia-user-login="AbelD" class="lia-mention lia-mention-user">AbelD</a>&nbsp;Hi! Can you better explain the expected result?</P> <P>&nbsp;</P> <P>BBF</P> Mon, 30 Jan 2023 11:13:00 GMT BeaBF 2023-01-30T11:13:00Z Loopupvalue https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Loopupvalue/m-p/3050024#M105019 <P>I have 2 tables and looking for a formula that can look up a range thus search 4 and bring results in row 2</P><TABLE border="1"><TBODY><TR><TD>Entry</TD><TD>Account</TD><TD>User</TD></TR><TR><TD>1</TD><TD>xx</TD><TD>xxx</TD></TR><TR><TD>2</TD><TD>xx</TD><TD>xxx</TD></TR><TR><TD>3</TD><TD>xx</TD><TD>xxx</TD></TR><TR><TD>4</TD><TD>xx</TD><TD>xxx</TD></TR></TBODY></TABLE><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Entry from</TD><TD>Entry to</TD><TD>Account</TD></TR><TR><TD>1</TD><TD>2</TD><TD><P>&nbsp;</P></TD></TR><TR><TD>3</TD><TD>5</TD><TD><P>xxx</P></TD></TR></TBODY></TABLE> Mon, 30 Jan 2023 09:34:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Loopupvalue/m-p/3050024#M105019 AbelD 2023-01-30T09:34:27Z Re: Loopupvalue https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Loopupvalue/m-p/3050214#M105033 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="506514" data-lia-user-login="AbelD" class="lia-mention lia-mention-user">AbelD</a>&nbsp;Hi! Can you better explain the expected result?</P> <P>&nbsp;</P> <P>BBF</P> Mon, 30 Jan 2023 11:13:00 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Loopupvalue/m-p/3050214#M105033 BeaBF 2023-01-30T11:13:00Z Re: Loopupvalue https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Loopupvalue/m-p/3050268#M105037 <P>If the entry is 2 it must filter only row 1, as 2 is between 1 and 2</P> Mon, 30 Jan 2023 11:43:16 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Loopupvalue/m-p/3050268#M105037 AbelD 2023-01-30T11:43:16Z