https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/lookupvalue-Help/m-p/3064614#M156873 <P>Hello,</P><P>I am new to power BI and DAX.&nbsp; I am trying to do a lookupvalue function between 2 tables.&nbsp; First, the tables are direct query.&nbsp;&nbsp;</P><P>&nbsp;</P><P>TableA has a date field that I need to add to TableB.&nbsp; Both tables have a recordID.&nbsp;</P><P>TalbeA has unique recordID, but TableB has duplicate entries for the recordID.</P><P>I just want to add the date from TableA to TableB, even to the duplicate recordID in TableB.&nbsp; I am getting errors when trying the lookupvalue function.&nbsp; Is there another way?</P><P>&nbsp;</P><P>Thank you in advance.</P> Mon, 06 Feb 2023 19:43:28 GMT AJUAC 2023-02-06T19:43:28Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/lookupvalue-Help/m-p/3064614#M156873 <P>Hello,</P><P>I am new to power BI and DAX.&nbsp; I am trying to do a lookupvalue function between 2 tables.&nbsp; First, the tables are direct query.&nbsp;&nbsp;</P><P>&nbsp;</P><P>TableA has a date field that I need to add to TableB.&nbsp; Both tables have a recordID.&nbsp;</P><P>TalbeA has unique recordID, but TableB has duplicate entries for the recordID.</P><P>I just want to add the date from TableA to TableB, even to the duplicate recordID in TableB.&nbsp; I am getting errors when trying the lookupvalue function.&nbsp; Is there another way?</P><P>&nbsp;</P><P>Thank you in advance.</P> Mon, 06 Feb 2023 19:43:28 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/lookupvalue-Help/m-p/3064614#M156873 AJUAC 2023-02-06T19:43:28Z