Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
DAX Query
  • PritamA's avatar
    PritamA
    3 years ago
    May be try this ........
    CALCULATE(SUM('Table_X'[Column_Y]),
    FILTER('Calendar',MONTH('Calendar'[Date]) = MONTH(TODAY())-1))
PritamA's avatar
PritamA
Frequent Visitor
3 years ago
May be try this ........
CALCULATE(SUM('Table_X'[Column_Y]),
FILTER('Calendar',MONTH('Calendar'[Date]) = MONTH(TODAY())-1))