Get sum of quantity of current month - 2

[Anonymous]

Hi,

 I am looking to get sum of quantity by using following dax.

current month quantity = CALCULATE([Qty],Dates[Date],

FILTER(Dates,

Dates[Date] = MAX('Reporting Dates'[Date])

))

'Dates' is a date table containing dates till the entire year.

'Reporting Dates' is a table which has dates till current month.

I would like to alter the dax to show quantity for January end. i.e., current month March - 2.

I tried putting -2 after "MAX('Reporting Dates'[Date])" in the above dax, but it isnt working.

Any tips would be appriciated. 

[Arul]

@Anonymous ,

try this

Two month back sales = 
CALCULATE (
    [Qty],
    FILTER (
        'Dates',
        MONTH ( 'Dates[Date] )
            = MONTH ( MAX ( Reporting Dates] ) ) - 2
    )
)

Thanks,

Arul

[amitchandak · Accepted solution]

@Anonymous , If no date is selected

or

2nd Last Month Today =

var _today =maxx( allselected('Reporting Dates')  , 'Reporting Dates'[Date])
var _min = eomonth(_today,-3)+1
var _max = eomonth(_today,-2)
return CALCULATE([Qty], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

2nd Last Month Today =
var _min = eomonth(today(),-3)+1
var _max = eomonth(today(),-2)
return CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

Last Month Today =
var _min = eomonth(today(),-2)+1
var _max = eomonth(today(),-1)
return CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))