if then else & try otherwise in Power Query M Language
The if-then-else construct is used for conditional logic
The try-otherwise construct in Power Query M Language is used for error handling and is useful when errors might occur, and you don’t want the query to crash while running
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Please checkout my book, Power Query M Language Basics Kindle Edition
https://www.amazon.com/dp/B0DM73H3RV
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~