https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Custom-Column-There-s-not-enough-memory-to-complete-this/m-p/3731923#M145438 <P>use variables instead of EARLIER.&nbsp; Prefilter your table variable with the test name.&nbsp; Use DAX Studio to examine the query plan and see where the cartesian kicked in.</P> Thu, 29 Feb 2024 00:57:23 GMT lbendlin 2024-02-29T00:57:23Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Custom-Column-There-s-not-enough-memory-to-complete-this/m-p/3731191#M145407 <P>I have used the following DAX for two tables formated the same way. For some reason when I try to use the same formula for this table I get the error "There's not enough memory to complete this operation."</P><P>&nbsp;</P><P>My dax is as follows:</P><P><img /></P><P>&nbsp;</P> Wed, 28 Feb 2024 16:27:59 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Custom-Column-There-s-not-enough-memory-to-complete-this/m-p/3731191#M145407 MLH4 2024-02-28T16:27:59Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Custom-Column-There-s-not-enough-memory-to-complete-this/m-p/3731923#M145438 <P>use variables instead of EARLIER.&nbsp; Prefilter your table variable with the test name.&nbsp; Use DAX Studio to examine the query plan and see where the cartesian kicked in.</P> Thu, 29 Feb 2024 00:57:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Custom-Column-There-s-not-enough-memory-to-complete-this/m-p/3731923#M145438 lbendlin 2024-02-29T00:57:23Z