From the course: Mastering Business Intelligence with DAX, Power BI, and Excel by Microsoft Press

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Use basic aggregations

Use basic aggregations

From the course: Mastering Business Intelligence with DAX, Power BI, and Excel by Microsoft Press

Start my 1-month free trial Buy for my team

Use basic aggregations

“

- So far, you have seen that you can use decks to create calculated columns, which you should do as little as possible, to create calculated tables and measures. You have also seen some examples already and learned about the syntax of decks, but we'll dive deeper into that now. Let's look at a very simple example. One of the most basic DAX functions is the SUM. The syntax for this function is simple. The name is SUM, and it expects exactly one argument, which should be a column name. The column itself should contain values of a number format, otherwise it cannot sum the values. What would a sum of text values even be? What the function then does is adding up all the numbers in that column, as the name of the function would suggest. An example is revenue = SUM(fSales[Amount]), which adds all the values in the column amount of the table fSales. The result of this measure, if this measure is one single value, which is…

Contents