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.

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

[SystemsDeptKIOCL]

Brilliant. I love this as this was the easiest way of using cell value as parameter

[hoanganphanle]

Is there a way to do this but with 2 filtered value instead of 1 ? Like I want to filter to get X and Y instead of just X ?

[ahmadhashemi]

I like it, but you speak too fast for me as non English mother tongue