Cumulative total vs last year stopping at today

[Explico]

I'm trying to make Total cumulative sales compared to the previous year's chart and I'm struggling to stop the chart:

My measure is as follows:

Cumulative sales = 
--current day of year:
var _max = datediff(date(year(maxX(allselected(SalesDB), SalesDB[Date])),1,1),maxX(allselected(SalesDB), SalesDB[Date]),DAY)+1
return
CALCULATE (
    sum(SalesDB[SalesAmount]),
    FILTER (
        ALL ( SalesDB ),
        SalesDB[Date] <= MAX (SalesDB[Date])
            && SalesDB[Day_of_year] <= _max  --add only this day of year
            && SalesDB[Year]=year(max(SalesDB[Date])) --resets yeach year
    )
)

Any idea - how to stop this chart at today's Day_of_year?

I do have a more simple measure which stops just fine, but it is not cumulative:

Sales till today = 
--current day of year
var _max = datediff(date(year(maxX(allselected(SalesDB), SalesDB[Date])),1,1),maxX(allselected(SalesDB), SalesDB[Date]),DAY)+1
return
calculate(sum(SalesDB[SalesAmount]), filter(SalesDB, SalesDB[Day_of_year]<=_max))

Thanks!

[fhill]

I'll start playing with the DAX code, but I'm thinking we'll have to add an IF statement, so that if the Day of Year is > Current Year, Day of Year, then BLANK(), else do you Culmative calculation?

Forrest

Cumulative sales = 
--current day of year:
var _max = datediff(date(year(maxX(allselected(SalesDB), SalesDB[Date])),1,1),maxX(allselected(SalesDB), SalesDB[Date]),DAY)+1
return
CALCULATE (
    sum(SalesDB[SalesAmount]),
    FILTER (
        ALL ( SalesDB ),
        SalesDB[Date] <= MAX (SalesDB[Date])
            && SalesDB[Day_of_year] <= _max  --add only this day of year
            && SalesDB[Year]=year(max(SalesDB[Date])) --resets yeach year
    )
)

[fhill · Accepted solution]

OK, here's my version of what you have...  

... and here's my IF Statement that DOES NOT do the Calcuatle math if Day_Of_Year in the talbe is Greater than Today's Day of Yyear....