Get Started. It's Free
or sign up with your email address
DAX by Mind Map: DAX

1. References

2. Elements

2.1. Measures

2.1.1. Total Sales:=SUM([Sales Amount])

2.2. Calculated columns

2.2.1. =[Calendar Year] & " Q" & [Calendar Quarter]

2.3. Calculated tables

2.3.1. example

2.3.2. Functions

2.4. Row filters (Row-level security)

2.4.1. =Customers[Country] = "USA"

2.5. Queries

2.5.1. EVALUATE ( FILTER ( 'DimProduct', [SafetyStockLevel] < 200 ) ) ORDER BY [EnglishProductName] ASC

2.6. Formulas

2.6.1. Days in Current Quarter = COUNTROWS( DATESBETWEEN( 'Date'[Date], STARTOFQUARTER( LASTDATE('Date'[Date])), ENDOFQUARTER('Date'[Date])))

2.7. Functions

2.7.1. Date and time functions

2.7.2. Filter functions

2.7.2.1. 1

2.7.2.2. 2

2.7.3. Information functions

2.7.4. Logical functions

2.7.5. Mathematical and trigonometric functions

2.7.5.1. 1

2.7.5.2. 2

2.7.6. Other functions

2.7.7. Statistical functions

2.7.7.1. 1

2.7.7.2. 2

2.7.7.3. 3

2.7.7.4. 4

2.7.8. Text functions

2.7.9. Time-intelligence functions

2.7.9.1. 1

2.7.9.2. 2

2.7.10. Table-valued functions

2.7.10.1. FILTER, ALL, VALUES, DISTINCT, RELATEDTABLE

2.8. Variables

2.8.1. ex.

2.9. Data types

2.9.1. eg

2.10. Context

2.10.1. Row context: This formula gets the tax rate for the current region from the Region table and adds it to the value of the Freight column. In DAX formulas, you do not need to know or specify the specific relationship that connects the tables.

2.10.1.1. = [Freight] + RELATED('Region'[TaxRate])

2.10.2. Multiple row context: For example, suppose your model contains a Products table and a Sales table. Users might want to go through the entire sales table, which is full of transactions involving multiple products, and find the largest quantity ordered for each product in any one transaction.

2.10.3. Query context

2.10.4. Filter context

2.10.5. Determining context in formulas

2.11. Operators

2.11.1. Working with tables and columns

2.11.1.1. Referring to tables and columns in formulas

2.11.1.1.1. =SUM('New Sales'[Amount]) + SUM('Past Sales'[Amount])

2.11.1.2. Table relationships

2.12. Process and refresh

2.13. Troubleshooting

3. Syntax

3.1. exambple

4. DAX operators

4.1. Arithmetic operators

4.2. Comparison operators

4.3. Text concatenation operator

4.4. Logical operators

4.5. Operator precedence