Reference a cell in Power Query for Excel or a parameter for Power BI

It can be useful when building queries with Power Query for Excel or Power BI to reference a value changeable by the user. Parameters are made for this, and work nicely in Power BI but less well in Excel where you would typically want users to edit a value in a cell. In this video I show both methods and when you might want use a certain one. I look at filtering, a data source on one's local computer and conditional columns which all have use cases to avoid hard coded values.
You can download the example files here: www.xlconsulting-asia.com/you...
00:00 Introduction
00:44 Create parameter from an Excel cell value
03:30 Conditional column
04:56 Get data from file/folder
05:20 Useful options
08:15 Manage parameters in Power BI
13:34 Manage parameters in Excel