Forum Discussion
error messages when applying changes
Hi Anonymous ,
When you want to combine number and text, you could try below M code
= Table.AddColumn(#"Changed Type", "Custom", each [text column]&Number.ToText([number]))In addition, you also need to check whether there is any other error in your power query
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
From that error message it appears that you are at some point creating a custom column. In this custom column you are trying to add the values of two columns together where one contains values that are not numeric.
From what i can tell it is the right column in the expression that is the problem as it contains "DIRSHRO30" which is a text value.
I don't really know what the appropriate action here is, as i don't know the purpose of the custom column. You could filter away the text values beforehand if the rows are not relevant.
Br,
J
Thanks for the help Tex. I have been working hard to extract all errors from my queries. However, with one of them the Keep Rows trick does not work. I get the following message when I try to collect the errors with your way of working:
Expression.Error: We cannot apply operator + to types Number and Text.
Details:
Operator=+
Left=0
Right=DIRSHRO30
This time inside the query editor. It seems as if this is now also the one stopping my query from being applied.
Thanks again for taking the time to help!
Hi Anonymous ,
When you want to combine number and text, you could try below M code
= Table.AddColumn(#"Changed Type", "Custom", each [text column]&Number.ToText([number]))In addition, you also need to check whether there is any other error in your power query
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.