Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I have certain fields such as unit cost, quantity etc. in my datset but i just read that after using analyze in excel feature,Excel PivotTables do not support drag-and-drop aggregation of numeric fields as in the microsoft doc.
How can i convert these fields into measures to support the aggregation or any other way by which i can add these fields in the values of the pivot table.
Any help would be appreciated.
Solved! Go to Solution.
@Anonymous
I am afraid you can only use predefined measure that means you have to create measures before you analyze in excel.
See Requirements:
"Excel PivotTables do not support drag-and-drop aggregation of numeric fields. Your dataset in Power BI must have pre-defined measures. Read about creating measures."
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous
I am afraid you can only use predefined measure that means you have to create measures before you analyze in excel.
See Requirements:
"Excel PivotTables do not support drag-and-drop aggregation of numeric fields. Your dataset in Power BI must have pre-defined measures. Read about creating measures."
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
131 | |
108 | |
101 | |
67 | |
64 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |