Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Previous Month Not working

Hi,

 

Can anyhone see what is wrong with this calculation... deos not seem to be working..

 

Previous Month := CALCULATE(SUM(Query[Net]),PREVIOUSMONTH(Table2[Date]))

 

Error message is saying the expression is not valid and the syntax for '(' is incorrect.

 

Thanks

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Dan,

     

    Was missing the relationship .. fixed now.;

     

    Thanks

4 Replies

  • themistoklis's avatar
    themistoklis
    Community Champion
    7 years ago

    Anonymous

     

    The syntax looks correct. 

     

    Need to check the connection between the tables Query and Table2

     

    Also make sure you dont have any redundant brackets in the formula

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    HI Anonymous,

    DAX formula is correct and no syntax error 

     

    Please, check your Query and Table2 connection in relationship. It may be possibility that you haven't marked your date table as "Mark as a date table". Time intelligence function will only work if your custom date table is marked with "Mark as a date table"

    Thanks,
    Amit

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous,

    Based on my test, it could work on my side:

    Could you please share your file to have a test?

     

    Regards,

    Daniel He

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Dan,

       

      Was missing the relationship .. fixed now.;

       

      Thanks