Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all, I'm new to Power BI and created a few reports from excel, which had no problem automatically aggregating text columns until now.
I've loaded data from a simple excel file and it won't aggregate columns. When I go to 'modeling' the 'sum' option is greyed out. Any suggestions? What have I done wrong?
Solved! Go to Solution.
You have to change your data type to integer or decimal.
Either from the Data View: Modelling > Change Data Type or Power Query.
You have to change your data type to integer or decimal.
Either from the Data View: Modelling > Change Data Type or Power Query.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |