Forum Discussion
Limitations in calculated field in pivot table ?
Im making a report based on a survey, to make it more interactive i use calculated field. But it seems that i can only make 10 separate calculated fields in one pivot table ?
2 Replies
As for the data model it has practically no any limits (more exactly they are, but big enough to reach in practice). Here everything is limited by available memory and CPU (from performance point of view).
I was not aware of any limitation to the number of Calculated Fields, that's a bummer. Is it possible to load your data into the data model then use Power Pivot? I have never noticed a limitation in Power Pivot data model to the count of Calculated Columns and Measures.
You might need to learn a little bit more about DAX however, I think you'll find it to be an exciting tool to use.
