![]() ![]() ![]() It's a long name, I know, but you'll see why in a bit. Create a Custom Column using the following formula:įor this example, I renamed my query to XL_TopX_NamedCell.One of the instructions I gave in the post last week was to: The challenge here is not from the end user's perspective, it's from the developer's. They simply change a cell value, hit refresh, and all is good. It puts control of the grouping in Excel, allowing a friendly user interface for the end user to work with. In that post, I pulled a Top 5 value from an Excel cell, and used that to drive how I grouped my items. Let's take a look my last technical blog post to understand this. And is that really something you want your boss doing? So why do we care about creating dynamic parameters, anyway? ![]() Sure, you can set up a list and change them at run time, but you have to enter the Power Query editor to do that. The reason for this is two-fold: the first is because I was used to it, the second was because the built-in Parameters are quite static. A couple of years ago, the Power Query team added Parameters as a proper object, but I kept on Creating Dynamic Parameters in Excel Power Query the same way as I always had. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |