https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-value-in-previous-day-that-goal-is-not-blank/m-p/2676446#M79998 <P>Hi guys!&nbsp;<BR /><BR />I want to sum the quantity sold on a day that my target is blank to the quantity sold on a day immediately before that target has a value.&nbsp;<BR />The expected result is:&nbsp;</P><P><img /></P><P>Can anyone help me to do this using DAX?</P> Tue, 02 Aug 2022 19:16:13 GMT mariana_carmof 2022-08-02T19:16:13Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-value-in-previous-day-that-goal-is-not-blank/m-p/2676446#M79998 <P>Hi guys!&nbsp;<BR /><BR />I want to sum the quantity sold on a day that my target is blank to the quantity sold on a day immediately before that target has a value.&nbsp;<BR />The expected result is:&nbsp;</P><P><img /></P><P>Can anyone help me to do this using DAX?</P> Tue, 02 Aug 2022 19:16:13 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-value-in-previous-day-that-goal-is-not-blank/m-p/2676446#M79998 mariana_carmof 2022-08-02T19:16:13Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-value-in-previous-day-that-goal-is-not-blank/m-p/2678925#M80140 <P>If you have a Date table linked to both sales and targets then I think the below should work</P><LI-CODE lang="markup">Sales amended = IF ( NOT ISBLANK ( SUM ( Targets[Goal] ) ), VAR currentDate = SELECTEDVALUE ( 'Date'[Date] ) VAR nextNonBlank = CALCULATE ( FIRSTNONBLANK ( 'Date'[Date], SUM ( Targets[Goal] ) ), 'Date'[Date] &gt; currentDate ) RETURN CALCULATE ( SUM ( Sales[Sales made] ), DATESBETWEEN ( 'Date'[Date], currentDate, nextNonBlank - 1 ) ) )</LI-CODE> Wed, 03 Aug 2022 14:26:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-value-in-previous-day-that-goal-is-not-blank/m-p/2678925#M80140 johnt75 2022-08-03T14:26:20Z