SUBTRACT on columns

[JulioCastillo]

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.

[JulioCastillo]

@Greg_Decklera Power Query (M) solution would be also highly appreciated. Thanks for your patience wie a Power BI newbie.

[Greg_Deckler · Accepted solution]

@JulioCastillo I believe it is like try otherwise, M Language Error Handling - PowerQuery M | Microsoft Learn

[Greg_Deckler]

@JulioCastillo Maybe:

IF(ISERROR([Old Value] - [New Value]),BLANK(), [Old Value] - [New Value])

[JulioCastillo]

Hello,

I get the following error message. Expression Error (IF) has not been recognized.

[Greg_Deckler]

@JulioCastillo 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