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
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
Okay understood, Thing is. Why does this only pop up when selecting "keep rows"> keep all with errors.
Because this error message does not show up at any time before I try this option?
I'm not entirely sure but my guess is that power query attempts to perform the action of keeping only error rows but can not complete that action due to another error.