Forum Discussion
Power Query M code equivalent to "iferror" function
Hi, Please can you tell me the Power Query M code equivalent for the "iferror" function in excel? Thanks, CM
use "try....otherwise".
try <some code hear that may result in an error> otherwise <run this code in case of error>
note that try and otherwise are NOT capitalized. Also, no commas are needed.
Hi Anonymous,
Related documentations: https://msdn.microsoft.com/en-us/library/mt186368.aspx and https://msdn.microsoft.com/en-US/library/mt267542.aspx.
Best Regards!
Dale