Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have this function that calculates column total and places it on every row. It works OK if it is placed in the stand-alone query, but it fails when placed into a function.
= Table.AddColumn(#"Removed Columns", "Inv sum", each List.Sum ( #"Removed Columns"[#"Q-ty"] ))
I end up with this error message: "Expression.Error: We cannot apply operator - to types Text and Text."
How do I go around this?
Solved! Go to Solution.
Well, it turns out that one has to be careful with column format definition. If you have column in general format, it adds up ok in stand-alone query, but fails if the query is organized as a function. When I define column as Decimal or Integer it all works as expected both in stand-alone query and function.
Well, it turns out that one has to be careful with column format definition. If you have column in general format, it adds up ok in stand-alone query, but fails if the query is organized as a function. When I define column as Decimal or Integer it all works as expected both in stand-alone query and function.
Hi @gvg,
It seems that you have solved your problem, please accept the your replies making sense as solution to your question so that people who may have the same question can get the solution directly.
Best Regards,
Cherry
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |