https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-formula-error/m-p/3873215#M151291 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="733143" data-lia-user-login="RiddhimaC" class="lia-mention lia-mention-user">RiddhimaC</a>&nbsp;</P> <P>&nbsp;</P> <P>You can get your required output in the following way, for example.&nbsp;</P> <P>&nbsp;</P> <P><img /></P> <P>An example pbix file is attached below.</P> <P>Best regards,</P> Sun, 28 Apr 2024 14:25:12 GMT DataNinja777 2024-04-28T14:25:12Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-formula-error/m-p/3872606#M151278 <P><SPAN>im using this cumulative formula ---- Cumulative_orders = calculate(SUM('New folder'[quantity]),FILTER(all('New folder'[orderDate]),'New folder'[orderDate]&lt;=(1+MAX(('New folder'[orderDate]))))) but the cumulative column is returning same values and not sum that 1,2,8, 10 is returning as 1,2,8,10 but not 1,3,11,21<BR /><LI-MESSAGE title="DAX - Cumulative count for only active customer" uid="3584861" url="https://community.fabric.microsoft.com/t5/Desktop/DAX-Cumulative-count-for-only-active-customer/m-p/3584861#U3584861" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"></LI-MESSAGE>&nbsp;<BR /></SPAN></P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Sat, 27 Apr 2024 22:08:35 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-formula-error/m-p/3872606#M151278 RiddhimaC 2024-04-27T22:08:35Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-formula-error/m-p/3873215#M151291 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="733143" data-lia-user-login="RiddhimaC" class="lia-mention lia-mention-user">RiddhimaC</a>&nbsp;</P> <P>&nbsp;</P> <P>You can get your required output in the following way, for example.&nbsp;</P> <P>&nbsp;</P> <P><img /></P> <P>An example pbix file is attached below.</P> <P>Best regards,</P> Sun, 28 Apr 2024 14:25:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-formula-error/m-p/3873215#M151291 DataNinja777 2024-04-28T14:25:12Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-formula-error/m-p/3873329#M151301 <P>nope no luck, still the same. Not sure where Im going wrong. I combined and loaded 3 files from a folder BTW and then sorted ACC to date...</P><P><img /></P><P>&nbsp;</P> Sun, 28 Apr 2024 17:09:57 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-formula-error/m-p/3873329#M151301 RiddhimaC 2024-04-28T17:09:57Z