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

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