Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Hope you are creating this as a new Table
I was but deleting the table from the advanced editor and leaving the formula seems to have solved the problem
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |