How to display total sales until selected month (from slicer)

[adriansuteu]

Hello.

Let's assume the following situation:

$1000 - sales on March

$2000 - sales on April.

If I select March from slicer the graph shows 1000, if I select April from slicer the graph shows $2000, but I want it to show the Total sales until April included ($3000).

I have tried the following formula but it does not work:

Total Sales= Calculate(sum('Open Courses'[New Sales]), filter('Open Courses','Open Courses'[Date] <= calculate(max('Calendar'[DateKey]))))

I have a 1to* relationship between Calendar[DateKey] and Open Courses[Date].

Please help me figure it out!

[fhill]

Check out this article on creating a Cumulative Custom Column in your data...  

https://community.powerbi.com/t5/Desktop/DAX-Running-Total-YTD/td-p/21576

I used this to create the 'Cumulative by Date' graph on the far right below.  (Bars show filter boarders).

P.S.  It seems like a 'Before' slicer might be even easier.  See my 2 middle examples where I just use a standard card of 'Sales' with the Slicer and the 'Before' option to only select end dates?  ( You said drop down, so that might not help you..)

Cumulative =
VAR RowDate = Table5[Date]
RETURN
CALCULATE (
SUM ( Table5[Sales] ),
FILTER (
Table5,
Table5[Date] <= RowDate
)
)