In this file, I am getting the "Circular dependency error" when refreshing the PowerPivot Table. Could you kindly help me resolve the issue.
Here is the file - http://sdrv.ms/19Xua8c
Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com
I just took a look at your model and the first question that arises is why you use calculated columns for your calculations?
I think all (or at least most) of them can be also achieved using calculated measures - assuming that you finally put Year and Month on rows in your pivot-table
further, adding a Date-Table would allow you to use TimeIntelligence functions like PREVIOUSMONTH() for your calculated measures
- www.pmOne.com -
Thank you very much for your suggestion. I did exactly as you said and not only did I get the correct result but also, got rid of the error.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?