Forum Discussion
DAX QUERY PREVIOUS MONTH
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
- May be try this ........
CALCULATE(SUM('Table_X'[Column_Y]),FILTER('Calendar',MONTH('Calendar'[Date]) = MONTH(TODAY())-1))
1 Reply
- May be try this ........
CALCULATE(SUM('Table_X'[Column_Y]),FILTER('Calendar',MONTH('Calendar'[Date]) = MONTH(TODAY())-1))