Previous Month Not working

[Anonymous]

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

[Anonymous]

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]

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 · Accepted solution]

Hi Dan,

Was missing the relationship .. fixed now.;

Thanks

[themistoklis]

@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