https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Optimizing-ALLEXCEPT-Getting-the-next-date-per-categories/m-p/1785227#M37493 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="149408" data-lia-user-login="zaza" class="lia-mention lia-mention-user">zaza</a> , Try a new column like </P> <P>minx(filter(Calls, [Customer] =earlier([Customer]) &amp;&amp; [Date] &gt; earlier([Date]) &amp;&amp; [Type] = "OUTBOUND"),[Date])</P> Wed, 14 Apr 2021 17:33:18 GMT amitchandak 2021-04-14T17:33:18Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Optimizing-ALLEXCEPT-Getting-the-next-date-per-categories/m-p/1784488#M37466 <P>I wrote this calculated column and it works perfectly, but the problem is that it takes way too much time to load. Question is, how can I optimize this?</P><LI-CODE lang="markup">NextOutboundCall = VAR __call = Calls[Date] RETURN CALCULATE ( MIN ( Calls[Date] ), FILTER ( ALLEXCEPT ( Calls, Calls[Customer] ), Calls[Date] &gt; __call &amp;&amp; Calls[Type] = "OUTBOUND" ) )</LI-CODE><P>My data looks like this (I'm replacing results with blank where there are blanks):</P><P><img /></P><P>&nbsp;</P> Wed, 14 Apr 2021 11:48:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Optimizing-ALLEXCEPT-Getting-the-next-date-per-categories/m-p/1784488#M37466 zaza 2021-04-14T11:48:22Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Optimizing-ALLEXCEPT-Getting-the-next-date-per-categories/m-p/1785227#M37493 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="149408" data-lia-user-login="zaza" class="lia-mention lia-mention-user">zaza</a> , Try a new column like </P> <P>minx(filter(Calls, [Customer] =earlier([Customer]) &amp;&amp; [Date] &gt; earlier([Date]) &amp;&amp; [Type] = "OUTBOUND"),[Date])</P> Wed, 14 Apr 2021 17:33:18 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Optimizing-ALLEXCEPT-Getting-the-next-date-per-categories/m-p/1785227#M37493 amitchandak 2021-04-14T17:33:18Z