Forum Discussion
SUBTRACT on columns
Hello, I wanted to know if it's possible to Subtract a value in a new column from "Old Value" to "new Value". The issue I'm facing is that in both columns I have text and numbers. When now tryi...
Anonymous I believe it is like try otherwise, M Language Error Handling - PowerQuery M | Microsoft Learn
Anonymous Maybe:
IF(ISERROR([Old Value] - [New Value]),BLANK(), [Old Value] - [New Value])Hello,
I get the following error message. Expression Error (IF) has not been recognized.
Anonymous I gave you a DAX solution, do you want a Power Query (M) solution then I take it? I believe it is like try otherwise, M Language Error Handling - PowerQuery M | Microsoft Learn