Hands-On Business Intelligence with DAX by Ian Horne

Author:Ian Horne [Ian Horne]
Language: eng
Format: epub
Tags: COM051380 - COMPUTERS / Programming / Microsoft, COM018000 - COMPUTERS / Data Processing, COM005030 - COMPUTERS / Enterprise Applications / Business Intelligence Tools
Publisher: Packt
Published: 2020-01-31T04:17:21+00:00

We've gone through the function types and groups in this section. In the next section, we will learn about the aggregation functions.

Introduction to aggregation functions

As we have already seen earlier in this chapter, the DAX language consists of a large number of functions that can be grouped based on the type of functionality they provide. In this section, we are going to take our first detailed look at these groups, starting with a look at the aggregation group of functions.

Aggregation functions provide a way to summarize or group data and common examples include the AVERAGE, COUNT, MAX, MIN, and SUM functions. All of these have their equivalent X function, such as SUMX. Instead of working against a column of a table, these X functions apply the aggregation to the result of an expression that is evaluated for each row of a table.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.