Need Dax for Current Month sales

[Mattkarim9908]

I have sales data for 2 months Nov-21 and Dec-21 and currently I am in Jan-22. I need a dax to calculate Current month sales considering the last month in my calendar as current month that if next month I fall into Feb-22 and I get data for Jan-22 so my current month dax give me data for Jan-22 automatically.

[mh2587]

Last month Sale = calculate([saleAmount],DATEADD(DateTime[Date],-1,Month))

[amitchandak · Accepted solution]

@Mattkarim9908 , based on today,

This month Today =
var _min = eomonth(today(),-1)+1
var _max = eomonth(today(),0) //today()
return
CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Date] >= _min && 'Date'[Date] <=_max ) )

MTD=
var _min = eomonth(today(),-1)+1
var _max = today()
return
CALCULATE(sum('Table'[Qty]), FILTER(ALL('Table'),'Table'[Date] >= _min && 'Table'[Date] <=_max ) )

LMTD =
var _min = eomonth(today(),-2)+1
var _max1 = today()
var _max = date(year(_max1),month(_max1)-1, day(_max1))
return
CALCULATE(sum('Table'[Qty]), FILTER(ALL('Table'),'Table'[Date] >= _min && 'Table'[Date] <=_max ) )