Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

PREVIOUSMONTH & FITLER

Hi,    I am trying to report a previous month's number but only when another column is filtered. i would like the model to report the previous month count for when it is terminated.  i have tried t...
  • Tahreem24's avatar
    Tahreem24
    6 years ago

    Try with IF:

    =IF(MAX(Sheet1[Status]="Terminated",CALCULATE(SUM(Sheet1[WSE]),PREVIOUSMONTH(Sheet1[Report Date])), "-")

     

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
6 years ago

Try with IF:

=IF(MAX(Sheet1[Status]="Terminated",CALCULATE(SUM(Sheet1[WSE]),PREVIOUSMONTH(Sheet1[Report Date])), "-")

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Tahreem24 Thank you for your assistance, unfortunately i received the below error when trying the Max function

    "The MAX function only accepts a column reference as an argument"