https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Return-information-from-different-tables/m-p/2736872#M83956 <P>Your question is unclear. If you want a specific code... why would you want to look it up if you already know it? Secondly, you should consolidate the tables into one. Then you won't have problems.</P> Wed, 31 Aug 2022 03:00:42 GMT daXtreme 2022-08-31T03:00:42Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Return-information-from-different-tables/m-p/2736257#M83930 <P>How do I find information in a table where the data can be found in three different columns of a different table?</P><P>Example:</P><P>Table A [Column A]</P><P>Return for 'Table A [Column A]' the code z001, which can be in any of the columns of 'Table B':</P><P>Table B [Column A]<BR />z002<BR />z003<BR />z001</P><P>Table B [Column B]<BR />z004<BR />z005<BR />z007</P><P>Table B [Column C]<BR />z008<BR />z001<BR />z009</P> Tue, 30 Aug 2022 19:39:47 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Return-information-from-different-tables/m-p/2736257#M83930 marcosvcortes 2022-08-30T19:39:47Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Return-information-from-different-tables/m-p/2736872#M83956 <P>Your question is unclear. If you want a specific code... why would you want to look it up if you already know it? Secondly, you should consolidate the tables into one. Then you won't have problems.</P> Wed, 31 Aug 2022 03:00:42 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Return-information-from-different-tables/m-p/2736872#M83956 daXtreme 2022-08-31T03:00:42Z