DAX Extract Text Before Delimeter Error when Subtracting

Anonymous Perhaps you need to check if it is blank or 0?

You must have a value without any "." in it. Then SEARCH ( ".", Home_Poject, 1, BLANK() ) will return 0 and the negative value will throw the calculation off.

You can add an if statement to handle the 0, something like if search() = 0 then 0 else search()

Hi Anonymous 

you can try this measure

Measure = LEFT(SUBSTITUTE(MIN('Table'[Column1])," ","."),SEARCH(".",SUBSTITUTE(MIN('Table'[Column1])," ","."))-1)

result

Best Regards,

Community Support Team _Tang

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