Power Query - Dynamic Range Detection

Learn how to discover the start and end of a data range within a file where the start and/or end of the data are not predictable. File Download Link: https://www.bcti.com//wp-content/YT_Downloads/BCTI_DetectDataRange.zip 00:12 Overview of the Problem 00:46 File Download Instructions 00:58 Solving the Problem 01:18 Examining the Static (i.e., Common) Solution 02:11 Creating a Dynamic Discovery Solution (Finding the Start of the Data) 03:15 Discovering the End of the Data 04:32 Testing the Dynamic Solution 05:26 Overview of the M Code Solution