Advanced functions

There are two type of functions that are different from each other: Table Calculation and Level of Detail.

Table Calculation functions

The Table Calculation functions are special in many ways. Mastering them requires practice, but many useful functions are Table Calculation. It's important to understand how they work, and how to use them. Let's start with the basics.

Table function basics

Table Calculation functions allow you to calculate the rank, the percentage of total, the difference, and much more. Here is an example of the same Measure, Quantity, with different table functions:

In the preceding screenshot you can see, by Year and Quarter, in the following:

• The sum of the quantity, the initial Measure.
• The rank—which quarter is the best across all Years and Quarters.
• The percentage of total—Q4 2018, for example, represents 12% of the total quantity of products purchased.
• Moving average—the value of each quarter is the average of the current value and the two previous. This...