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 trying to subtract only the numbers I get an error message.
Is there a Dax Formula to only do the subtract on the numbers ?
Or what would be your approach.
Thanks for your inputs.
Anonymous I believe it is like try otherwise, M Language Error Handling - PowerQuery M | Microsoft Learn
5 Replies
Anonymous Maybe:
IF(ISERROR([Old Value] - [New Value]),BLANK(), [Old Value] - [New Value])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
Greg_Decklera Power Query (M) solution would be also highly appreciated. Thanks for your patience wie a Power BI newbie.
Anonymous I believe it is like try otherwise, M Language Error Handling - PowerQuery M | Microsoft Learn