Forum Discussion

AmberM's avatar
AmberM
Icon for Helper II rankHelper II
8 years ago
Solved

Error Message in Calculation: A function 'MAX' has been used in a True/False expression that is used

I am receiving an error message in calculation: "A function 'MAX' has been used in a True/False expression that is used as a table filter expression. This is not allowed."   How do I fix the follow...
Need Help
  • RobertSlattery's avatar
    RobertSlattery
    8 years ago

    Ah, OK.  It's a calculated table, not a measure.  You enter the formula in the status bar when creating a table...

     

     

    Then you use the Period field in your filter...

    And set up the relationship to the calculated table...

    This was your problem all along I think.  Your original formula is actualy fine if you do it like this.

  • AmberM's avatar
    AmberM
    Icon for Helper II rankHelper II
    8 years ago

    Unfortunately that didn't work either. This is the error message I received. The data is based on a yyyyww level. Good idea though!

     

    new error message with LASTDATEoriginal error message with MAX