Forum Discussion
Solved
Can't work with aggregates because Power BI not recognizing column as numeric data
Ive dug through all the documentation and forum posts but can't seem to find a solution. Power BI will not recognize a column in my data as numeric which is preventing me from leveraging the aggregat...
Idrissshatila
Super User
Super UserHello gordoncappo ,
then there's a value im your field that is not a number that is preventing you from converting the column to an aggregate.
Hi Idrissshatila thank you for your response.
I don't know how that would be possible because there is no data error in power query and I can write a simple SUM formula on the column with no issue. Screenshot of the the column quality in power query.
- Idrissshatila
if you can write a sum measure then what's the problem, you could write a measure to aggregate.
I am wondering why it will not show the Numeric Field Sigma icon? Is there a setting I need to adjust?