Forum Discussion
Cannot apply VALUE on FILTERed table
Hello all, Context I have a table with a column named "Answer" I want to measure the average of all numerical answer. Because, see, some answer are numerical and some answer are textual, but b...
You cannot mix data types in the same column like you do with your Answer. So it will default to text in this case, and you cannot average text. Easiest thing to do is in Power Query, Reference the Main query, but filter down to just Numerical and then a simple average function over that answer column after you change the data type to a numerical one. I guess you could create a new column in the same table to only give a number, but why make it more complicated then it needs be?
actually if you put the following as a new column in Power Query, it works as well