Previous months orders with date filter in one table.

[DrewSmith]

In PowerBI I'm trying to calculate last months sales. I have a slicer for the date and this is where it's becoming stuck, I think. 
All data is in one table and I'm trying to essentailly calculate the sum of sales orders, if the include/exclude = Include, and the dates are one month prior to that selected on the slicer. 

I've tried:

Orders LM =

CALCULATE(

    SUM(Orders[quantity]),

    DATESBETWEEN(

        Orders[_Use Date],

        EOMONTH(TODAY(),-2)

        EOMONTH(TODAY(),-1)

    ),

    Orders[Include/Exclude] = "Include"

)

Which works, but it's not dynamic. A snippit of what the data looks like is below (drafted in Excel). 

[ryan_mayu]

@DrewSmith 

maybe try this

Orders LM =

CALCULATE(

    SUM(Orders[quantity]),

    DATESBETWEEN(

      all(  Orders[_Use Date]),

        EOMONTH(selectedvalue(date),-2)

        EOMONTH(selectedvalue(date),-1)

    ),

    Orders[Include/Exclude] = "Include"

)

[DrewSmith · Accepted solution]

Hi @ryan_mayu . 
Your answer gave me an idea and this worked: 

CALCULATE(sum(Orders[_SalesRev]), DATEADD(FILTER(DATESMTD(_Calendar[Date]), _Calendar[Date]<TODAY()), -1,MONTH))