Forum Discussion

RafalK's avatar
RafalK
Advocate IV
5 years ago
Solved

Columns don't aggregate

Hi, I have a problem with my report - my columns don't aggregate. The Summarization is set to Sum and still I see no sum icon next to the column and it acts like text once I drag and drop it to a t...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

RafalK you will have to check the data type in power query as well the data type in power query and power destop should match

Anonymous's avatar
Anonymous
Not applicable
5 years ago

RafalK  Also make sure that the below option is selected

  • RafalK's avatar
    RafalK
    Advocate IV
    5 years ago

    Thanks but as you can see on my screenshot it is.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      did you checkin power query ? what is the data type over there?

      Maybe the column has null values and when it imports it is not recognized as numbers because of that.

      I would take a look at the column in query editor and make sure it is set as Whole Number

      • RafalK's avatar
        RafalK
        Advocate IV
        5 years ago

        Power Query sets the columns as a Whole Number data type. There are no nulls.

        The problem is not related to this column alone but to all the columns in my report.

         

         

        I suspect this has something to do with either me using Tabular Editor.