Sum value in previous day that goal is not blank

[mariana_carmof]

Hi guys! 

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. 
The expected result is: 

Can anyone help me to do this using DAX?

[johnt75 · Accepted solution]

If you have a Date table linked to both sales and targets then I think the below should work

Sales amended =
IF (
    NOT ISBLANK ( SUM ( Targets[Goal] ) ),
    VAR currentDate =
        SELECTEDVALUE ( 'Date'[Date] )
    VAR nextNonBlank =
        CALCULATE (
            FIRSTNONBLANK ( 'Date'[Date], SUM ( Targets[Goal] ) ),
            'Date'[Date] > currentDate
        )
    RETURN
        CALCULATE (
            SUM ( Sales[Sales made] ),
            DATESBETWEEN ( 'Date'[Date], currentDate, nextNonBlank - 1 )
        )
)