Forum Discussion
jdunmall
Advocate I
Advocate IAnalyze in Excel: aggregation of numeric fields
I'm having trouble understanding how to use the new Analyze in Excel feature. The documentation says: Excel PivotTables do not support drag-and-drop aggregation of numeric fields. Your dataset i...
BruceAnderson
Helper II
Helper III just discovered this limitation and my excitement for Analyze in Excel went woosh!
I think we would have to make the measure in Power BI Desktop, but i have uploaded most of my reports from Excel data sources and to have to re-do them in Desktop would be a nightmare. Hoping there is a way to do this using something in Power BI Service and or Excel?
indeed,
it is NOGO for me as well