Forum Discussion
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...
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.
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.
Baskar
Resident Rockstar
Resident Rockstaryes u r correct . data cleaning is more important.
If u go with Power BI desktop we have several option to clean your data.