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

v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

Hi Dan,

 

Was missing the relationship .. fixed now.;

 

Thanks