|
|
| (6 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
| |
|
| |
|
| ==Data Types==
| |
| * 64-bit Integer
| |
| * 64-bit Real
| |
| * Boolean
| |
| * String
| |
| * DateTime
| |
| * Currency
| |
| * BLANK
| |
