Forum Discussion
Expression.Error: We cannot apply operator < to types Number and Text
Hello all, I have an below mentioned error Expression.Error: We cannot apply operator < to types Number and Text Details: Operator=< Left=4 Right=Q9_1 I get this while Pivoting , attached th...
Hello - Power Query is finding a text value when it expects a number. Based on your script, I would think that it is in the 'Value' column. I recomend you use Table.FindText before the #"Added Conditional Column" step to locate it. The text value causing the problem is 'Q9_1'.
Table.FindText ( #"Filtered Rows1", "Q9_1" )
Hello jennratten . Yes there is text value in the Value column, that causes this error.
Thanks for helping me out 👍