IFERROR in Power Query Using TRY OTHERWISE - My Online Training Hub
FBTwitterReddit
video description
Rating: 4.0; Vote: 1
IFERROR in Power Query Using TRY OTHERWISE - My Online Training Hub
Use try .. otherwise to trap and deal with errors in Power Query. Download the Excel file here: https://www.myonlinetraininghub.com/iferror-in-power-query-using-try-otherwise
00:18 Introduction to try .. otherwise
01:08 Using Remove Errors and Replace Errors
01:33 Using try to Check for Errors
01:50 Examining the Contents of Error Records
03:20 A Fast Way to Access Error Contents Using try
04:54 Using try .. otherwise to Replace Calculation Errors With a Default Value
06:02 Dealing With Errors Caused by a Missing Data Source
FreshWood: Usually I used if functions to do things like that but this way of handling errors is so much nicer - awesome video! I am curios how nested -try .. otherwise- functions will look like. Have you tested nested try functions in a script so far? Date: 2022-04-08
