Avoiding division by zero in Direct Query

[Anonymous]

I'm trying to connect to a database using direct query and creating a custom column where there is a division operation. How can I avoid division by zero if i cannot use the iferror function.

[jthomson]

Sorry, was forgetting you wanted it in direct query and not DAX

[Anonymous]

I'm trying to create a custom column in the query editor in which a division takes place.

[jthomson]

Using the divide function should allow you to put in the behaviour you want if you've got division by zero

[Anonymous]

I get an error "Expression.Error: The name 'divide' wasn't recognized.  Make sure it's spelled correctly".