cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jak82 Member
Member

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

1 ACCEPTED SOLUTION

Accepted Solutions
jak82 Member
Member

Re: Previous Month Not working

Hi Dan,

 

Was missing the relationship .. fixed now.;

 

Thanks

4 REPLIES 4
themistoklis New Contributor
New Contributor

Re: Previous Month Not working

@jak82

 

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

Community Support Team
Community Support Team

Re: Previous Month Not working

Hi @jak82,

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

1.PNG

Could you please share your file to have a test?

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jak82 Member
Member

Re: Previous Month Not working

Hi Dan,

 

Was missing the relationship .. fixed now.;

 

Thanks

Highlighted

Re: Previous Month Not working

HI @jak82,

DAX formula is correct and no syntax error 

Month Not working.JPG

 

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