Average Measure of a column returns error

[Anonymous]

When attempting to use this calulation on a card or table, Power BI gives this error "The function AVERAGE cannot work with values of type String"

This is the formula in PowerBI: =AVERAGE('Excel File'[A Test])

"A Test" in Excel is a column of only numbers.

What is my issue here? All of the solutions to this I've found revolve around the data in the column being stored as text or dates. The data I'm pulling is only numbers, aside from the header.  

[Ashish_Mathur]

Hi,

In the Query Editor, change the data type of the A Test column to decimal number.

[ryan_mayu]

@Anonymous 

select column A Test and check the data type. if it's text type, then convert to number