Forum Discussion
Anonymous
4 years agoNot applicable
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 ...
- 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
4 years agoNot applicable
Yes, and Text is the only option that appears.
Pragati11
4 years agoSuper User
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?
- Anonymous4 years agoNot applicable
I went into Power Query Editor and was able to change the data types there. Thanks so much for your help!