none
Handling calculation errors RRS feed

  • Question

  • Using M in PQ, how can I identify and treat an error like the IFERROR function in Excel?

    Monday, July 11, 2016 8:09 PM

Answers

  • To make a long story short:

    Excel:

    IFERROR(<expression>, <expression_if_error>)

    PQ:

    try <expression> otherwise <expression_if_error>

    Tuesday, July 12, 2016 12:16 PM

All replies