Forum Discussion

jel888's avatar
jel888
Regular Visitor
9 years ago
Solved

Field missing aggregate symbol

Hello,   I've cleaned and imported a workbook with one worksheet and 11 columns (fields).  All of the fields except one have the Aggregate symbol (sum symbol) in the Fields list except one.  I've g...
Need Help
  • jel888's avatar
    jel888
    9 years ago

    Found my answer (after thinking a little bit), there was a letter in place of a number in one cell in the given column that forced the entire column's data to not be recognized as a numeric data.  So I performed a better cleanup and reimported into Power BI.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi jel888,

Glad to hear that the issue is solved. You can accept your own reply as solution, that way, other community members would easily found the solution once they get same issues.


Thanks,
Lydia Zhang

cjlpowers's avatar
cjlpowers
Regular Visitor
9 years ago

I am seeing the same issue. I have verified all data is numeric by loading the CSV in Excel and using the ISNUMBER function to test all rows. The field was classified properly when the dataset was first imported however something changed over the last few days. I think this may be a bug as I dont see any other reason for the change in behavior.