TOP
# DAX-Lesson 1. What is DAX. Basic concepts.

## What is DAX?

## Basic functions of DAX

Filter functions
Mathematical functions
Statistical functions
Boolean functions
Date and time functions
Text functions
Information functions
## Calculations in PowerPivot

## Context in DAX formulas

### Related Articles:

Application for expanding the capabilities of PivotTables (PowerPivot)
DAX-Lesson 2. CALCULATE function

**DAX** is a formula language (decoded as **Data Analysis eXpressions** - expressions for data analysis), which was developed by the **Microsoft** company. This language is not independent, but intended only for automating calculations in the **PowerPivot** application for **MS Excel**.

In short, **DAX** are formulas for pivot tables. Most **DAX** functions have similar names and characteristics compared to normal **Excel** functions, but can only be used in **PowerPivot**. As you know, ordinary **Pivot tables** can contain calculation fields, but only simple arithmetic operations - addition-subtraction and multiplication-division - can be performed in these fields. To increase the functionality of calculation fields, **DAX** was created. In general, **DAX** is not a complicated language, as it may seem at first glance, you just need to understand the principles of its operation. The difference between **Excel** formulas and **DAX** formulas is that in **Excel** we operate on individual cells and ranges, while in **DAX** strong> can refer only to entire tables and their columns.

To work with **DAX** code, we need to **install PowerPivot** for **Excel 2010** or go to the tab of the same name in **Excel 2013**.

As in **Excel**, the **DAX** functions belong to certain categories, namely:

In **PowerPivot** the user can create calculated fields of two types: * Calculated Columns* and

** Calculated column** - an additional column that is created by the user in any table loaded in

** Measure** (

The same formulas can behave differently, depending on whether they are used in a * calculated column* or a

The **DAX** language also has such a concept as context, which is very important for understanding the functioning of formulas. Formulas in **PowerPivot** can be affected by filters applied in a PivotTable, relationships between tables, and filters in formulas. The context allows for dynamic analysis. When building and troubleshooting formulas, it's important to understand the purpose of the context.

So, in **DAX** there are three types of context: * filter context*,

** Filter context** is the set of values allowed in each column depending on the filter constraints that apply to the row or that are defined by the filter criteria in the formula.

** Line context** - actually corresponds to the concept of the current line. If a calculated column is created, the values in each individual row and the values in the columns related to the current row serve as the context of the row.

** Query context** - refers to a subset of data that is implicitly created for each cell of a pivot table depending on the row and column headers in the pivot table.

- 1. What is VBA, basic concepts.
- 2. Code Debugger
- 3. Working with worksheets (Sheets)
- 4. Working with cells (Ranges)
- 5. Properties
- 6.1. Data types (Variables)
- 6.2. Data types (Continued)
- 7.1. Conditions
- 7.2. Conditions (Continued)
- 8.1. Loops
- 8.2. Loops (Continued)
- 9. Procedures and functions
- 10. Dialog boxes (Dialog boxes)
- 11.1. Workbook events
- 11.2. Worksheet events
- 12.1. Custom forms
- 12.2. Controls
- 12.3. Controls (Continued)
- 12.4. Controls (Exercises)
- 13.1. Arrays
- 13.2. Arrays (Continued)
- 13.3. Arrays (Exercises)
- 14.1. Using Excel functions
- 14.2. Creating a custom function

- 1. What is SQL? SQL essentials.
- 2. Select data from a database (SELECT)
- 3. Sorting the result records (ORDER BY)
- 4. Filter records (WHERE)
- 5. Using wildcards (LIKE)
- 6. Computed (calculated) columns
- 7. Aggregate functions (MIN, MAX, AVG etc.)
- 8. Grouping of the resulting set (GROUP BY)
- 9. Subqueries
- 10. Combining records from two tables (INNER JOIN)
- 11. Outer join (LEFT, RIGHT, FULL JOIN)
- 12. Combining the resulting sets (UNION)
- 13. Insert new records (INSERT INTO)
- 14. Create a new table (CREATE TABLE)