|
|
| (7 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| ==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
| |
