Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

I cannot select "Average" for some data columns

Hello,   I have my report linked to an excel with a list of student names followed by columns for scores on 5 different assignments administered 6 times throughout the year (30 columns of data). I ...
Need Help
  • Pragati11's avatar
    Pragati11
    4 years ago

    Hi Anonymous ,

     

    In that case go to Power Query Editor and try to modify the datatype of this column.

    What datasource are you connecting to?

     

Pragati11's avatar
Pragati11
Super User
4 years ago

Hi Anonymous ,

 

The screesnhot that you have shared clearly shows that Mechanics 1 is a numeric type of column therefore you see summarisation as SUM, AVERAGE, etc.

On the other hand, Mechanics 2 is a text type of column therefore you see summarisation as FIRST, LAST, etc.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks for the quick response! is there an easy way to change the type of column?

    • Pragati11's avatar
      Pragati11
      Super User
      4 years ago

      Hi Anonymous ,

       

      Yes click on your column --> on the top ribbon --> modify datatype from Text to say whole number.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Unfortunately, the only option appearing under format is text. I will mention that all of the columns are identical in data, the only difference being the name of the column.

         

        Any thoughts?