How to fix dax operation error using Values or Format in the string

All negative numbers start with ' is this expected?

Eg: '-0999

Hi Mk60 

From your screenshots, you can see that the data type of the "F_PROP_DSCR" column is "Text", and the reason for the error in the DAX formula is that you can't compare the text with the value.
I think what you need to do is to clean up your data in Power Query Editor and change the "F_PROP_DSCR" column to numeric type. Then this DAX formula will work successfully.

1. Change the “F_PROP_DSCR” column to a numeric type in the Power Query Editor.

2. Remove error rows or replace error rows.

If there are fewer rows of text, you can also choose to manually replace the text value with the correct numeric value.

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.