Forum Discussion

paulraykelly's avatar
paulraykelly
Regular Visitor
9 years ago
Solved

Text column does not aggregate

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?

Need Help
  • Datatouille's avatar
    Datatouille
    9 years ago

    Hi paulraykelly

     

    You have to change your data type to integer or decimal.

     

    Either from the Data View: Modelling > Change Data Type or Power Query.

1 Reply

  • Datatouille's avatar
    Datatouille
    Solution Sage
    9 years ago

    Hi paulraykelly

     

    You have to change your data type to integer or decimal.

     

    Either from the Data View: Modelling > Change Data Type or Power Query.