Multiply and return BLANK

[Redraidas1]

I know that when we are using the DIVIDE function for something like 2 / 0 it will return blank value instead of an error message saying something like 'Infinity'. I wonder if there is any function or logic for handling something like 2 * BLANK Value? I would like to get a blank field rather than an error message, is there something similiar to the DIVIDE function that elegantly handles errors in multiplying?

I know there's the IFERROR function, however, it is very bad for performance and therefore I don't want to use it.

[parry2k · Accepted solution]

@Redraidas1 I don't think multiplying 2 x BLANK() will give an error, it will return BLANK()

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡