ADDCOLUMNS not working anymore

[DaPiranha]

I’m having a problem with an existing report. Every month I update it so that the date ranges are current but this month it’s not letting me. I have a date table which has started to produce an error:

The formula itself doesn’t show any errors but the Query Editor and Advance Editor show an error with ADDCOLUMNS. I’ve gone back a few versions just incase I’d done something silly last month but still get the same issue and I’ve done a search on ADDCOLUMNS which shows that it should be working ok. I can’t refresh the desktop report but the version uploaded refreshes fine with no errors. I’ve tried then downloading that version but get the same issue.

Any ideas what's suddenly going wrong?

[amitchandak]

Hope you are creating this as a new Table

[DaPiranha]

I was but deleting the table from the advanced editor and leaving the formula seems to have solved the problem