DAX: Difference between revisions
(→Syntax) |
(→Syntax) |
||
| Line 5: | Line 5: | ||
* DAX-Operatoren | * DAX-Operatoren | ||
* Verweise auf Modellobjekte | * Verweise auf Modellobjekte | ||
** table names can be in single Quotes, but don't have to if no blanks or name collision | ** table names can be in single Quotes, but don't have to if no blanks or name collision. | ||
Ship Date = 'Date' | Ship Date = 'Date' | ||
** column names in square brackets | ** column names in square brackets, but for reading purposes put table name as prefix | ||
Revenue = SUM([Sales Amount]) | Revenue = SUM([Sales Amount]) | ||
** measure names in square brackets | ** measure names in square brackets | ||
Revision as of 19:50, 5 March 2022
Syntax
<Calculation name> = <DAX formula>
Formeln setzen sich wie folgt zusammen:
- DAX-Funktionen
- DAX-Operatoren
- Verweise auf Modellobjekte
- table names can be in single Quotes, but don't have to if no blanks or name collision.
Ship Date = 'Date'
- column names in square brackets, but for reading purposes put table name as prefix
Revenue = SUM([Sales Amount])
- measure names in square brackets
Profit = [Revenue] - [Cost]
- Konstante Werte, wie z. B. die Zahl 24 oder der Literaltext „FY“ (für Fiscal Year, Geschäftsjahr)
- DAX-Variablen
- Leerraum