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?

     

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?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      For reference, here is a screenshot of some of the excel.

       

    • Pragati11's avatar
      Pragati11
      Super User
      4 years ago

      Hi Anonymous ,

       

      Did you click on the small drop-down icon as shown below to check other datatype options?

      Once you click on the drop-down, it will show you other data-types.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Yes, and Text is the only option that appears.