Excel Unplugged

Category Archives: Lists in Power Query

Utilizing Power Query Lists 3/3

Dynamically retaining only columns that contain Actual values from a Table This article is part 3 of the Using Power Query lists series. In this series, we will look ...

Transforming a Table to Top 10 (by values) and Others with Power Query

Utilizing Power Query Lists 2/3 This article is part 2 of the Using Power Query lists series. In this series, we will look at how we can use lists to do the ...

Filtering a Table to a List of Values in Power Query or Power BI

Knowing how to use Lists in Power Query or Power BI is like a superpower. This Post will show you how to filter a Table to a Dynamic List of Values by using Lists in ...