![]() Dynamically retaining only columns that contain Actual amounts from a Table.Changing a Table of Attributes and Values to retain only Top 10 Attributes (by values) and turns the rest to Others.Dynamically Filtering a Table to a List of Values (This post).This post will focus on Filtering a Table to a List of Values, but in the entire three posts series, we will look at how we can use lists to do the following: You should always keep a lookout for the curly braces as those indicate a list of values being passed to an M function. Very often, those lines of code will contain Lists (most Common steps to do so are Changed Type steps). So rarely do we use them on purpose, and yet, we use them all the time since Power Query writes a new line of M code every time you click any command in the graphical user interface (GUI). ![]() Lists are (in my humble opinion) the most underrated output of Power Query. Utilizing Power Query Lists Series – Part 1/3 ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |