DAX QUERY PREVIOUS MONTH

[kaushikrao896]

 How to  write DAX query to return previous month?  for example  Current month is November I want a record for previous Month October? Here is my DAX query

EVALUATE
SUMMARIZECOLUMNS(
Dates[YYYY-MM],
Dates[Mth Year],
\Dates[Default Start Date]
)
ORDER BY
Dates[YYYY-MM] DESC,
Dates[Default Start Date] DESC

[PritamA · Accepted solution]

May be try this ........
CALCULATE(SUM('Table_X'[Column_Y]),

FILTER('Calendar',MONTH('Calendar'[Date]) = MONTH(TODAY())-1))