November 2022
Beginner to intermediate
475 pages
9h 16m
English
In Chapter 9 we have looked at filtering data using (fairly) simple comparisons applied as parameters to the CALCULATE() function. These kinds of data filters are both simple and efficient, but they have limits on what they can achieve. This chapter will push the boundaries of what can be done to select and subset data through introducing you to the FILTER() function.
It may help to consider the FILTER() function as a “helper” or “auxiliary” function. That is, you rarely - if ever - use it as the principle function ...
