Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Avoiding division by zero in Direct Query

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.

Need Help

4 Replies

  • jthomson's avatar
    jthomson
    Solution Sage
    8 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

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

  • jthomson's avatar
    jthomson
    Solution Sage
    8 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

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