Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 the query below
let
Source = #"Data 1 Sheet",
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"Test Name", "Consumer", "Serving Position", "3_digit_Product_Code", "Sample_Name", "Unique Consumer ID", "Unique Product Code"}, "Attribute", "Value"),
#"Filtered Rows1" = Table.SelectRows(#"Unpivoted Other Columns", each Text.EndsWith([Attribute], "_JAR") or Text.Contains([Attribute], "JAR") or Text.Contains([Attribute], "jar") or Text.Contains([Attribute], "Jar")),
#"Added Conditional Column" = Table.AddColumn(#"Filtered Rows1", "Custom", each if [Value] = 1 then "Too Less" else if [Value] = 2 then "Too Less" else if [Value] = 3 then "Just About Right" else if [Value] >= 4 then "Too Strong" else null),
#"Inserted Literal" = Table.AddColumn(#"Added Conditional Column", "Literal", each 1),
#"Changed Type" = Table.TransformColumnTypes(#"Inserted Literal",{{"Literal", Int64.Type}}),
#"Pivoted Column" = Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[Custom]), "Custom", "Literal")
in
#"Pivoted Column"
Can someone help to solve this error, Thanks!
Solved! Go to Solution.
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 👍
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" )
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
72 | |
67 | |
25 | |
18 | |
12 |