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 table function is useful ...
