'Need to change a column (multiple data types) to be able to subtract it from a column (type number)

My data has multiple data types in it (text, true/false, and number) which I need to subtract from a column that is just number. I cannot just sort out the other data types because it keeps taking the entire column.

I keep getting an error that says "DAX comparison operations do not support comparing values of type Text with values of type True/False. Consider using the VALUE or FORMAT function to convert on one of the values."

I've tried this "NewValue = ([Value] = IsNumber(True), [Value], 0.0) as well as trying to use Format and Value inside an If statement. Nothing seems to work.

Any recommendations?

powerbi

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'Need to change a column (multiple data types) to be able to subtract it from a column (type number)

Sources

Related Questions