https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-Fix-there-errors/m-p/3072168#M106687 <P>This is really confusing. What errors do you want to fix? The formulas are weird altogether.&nbsp;<BR />So please start with describing what the errors are and what you are trying to achieve and how your data looks like.</P> Thu, 09 Feb 2023 14:49:01 GMT JirkaZ 2023-02-09T14:49:01Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-Fix-there-errors/m-p/3070595#M106678 <OL><LI>Item Code &amp; Profile ID = CustomerStock_Lookup[Item Code]Stock_Lookup[Item Code]&amp;" "&amp;CustomerStock_Lookup[Profile ID]Stock_Lookup[Profile ID]</LI><LI>Customer Stock Code = LOOKUPVALUE(CustomerStock_Lookup[Customer Stock Code],CustomerStock_Lookup[Item Code &amp; Profile ID],Sales[Item Code &amp; Profile ID])</LI><LI>Job Cost = RELATED()</LI></OL> Thu, 09 Feb 2023 01:27:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-Fix-there-errors/m-p/3070595#M106678 mcpamintuan 2023-02-09T01:27:48Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-Fix-there-errors/m-p/3072168#M106687 <P>This is really confusing. What errors do you want to fix? The formulas are weird altogether.&nbsp;<BR />So please start with describing what the errors are and what you are trying to achieve and how your data looks like.</P> Thu, 09 Feb 2023 14:49:01 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-Fix-there-errors/m-p/3072168#M106687 JirkaZ 2023-02-09T14:49:01Z