Monthly inventory

Thanks tringuyenminh92 i did very similar solution to this but i ran into a new problem with the measure below:

cumulative qty = CALCULATE(
    SUM(
        Transactions[value]
        );
        filter(
            ALL(
                Dates[date]);Dates[date] <= * last date here *)
                )

For example if i type in Date(2016,3,31) to the  * last date here * I get the result that that looking for, but if I get that date from for intance from a slicer (season from datetable e.g. 03-16 or full date 31.3.2016) and try to insert that to the * last date here * it gives me wrong outcome. For date from slicer i've tried DATE- and DATEVALUE- functions and neither of them have worked. I get the value from slicer with this measure:

choice = 
    CONCATENATEX (
        VALUES ( Dates[Date] );
        Dates[Date];
    )

One example of the final (not working correctly atm) measure would then be:

cumulative qty = CALCULATE(
    SUM(
        Transaction[value]
        );
        filter(
            ALL(
                Dates[Date]);Dates[Date] <= DATE(YEAR([choice];MONTH([choice];DAY([choice])
                )

Ill try to further elaborate what i im trying to achieve with this simple example:

Date          value

1.1.2016    1000

2.1.2016   -500

1.2.2016    700

3.2.2016   -200

Now when i would select 3.2.2016 i should get 1000 and when i would select 2.1.2016 I should get 500. Hopefully this clarified this a bit :)

This logic works fine if I type in the date but every time I try to use a value that is from slicer I get wrong outcome. Am i missing something with DATE-functions or am I trying to do this the wrong way?