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.
Solved! Go to Solution.
Based on my test, it could work on my side:
Could you please share your file to have a test?
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"