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 t...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Dan,

     

    Was missing the relationship .. fixed now.;

     

    Thanks

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