Calendar (CloseDate)
Dimension table for close date calendar
DE: Kalender (geschlossen)
Columns
| Column (EN) | Column (DE) | Type | Description |
|---|---|---|---|
| DateBK | Datum | dateTime | |
| TimeBK | TimeBK | dateTime | |
| DateDisplay | Datum (display) | string | |
| DateDisplayLong | Datum (lang) | string | |
| DateDisplayShort | Datum (kurz) | string | |
| Year | Jahr | int64 | |
| Halfyear | Halbjahr | string | |
| YearHalfyear | Jahr-Halbjahr | string | |
| Quarter | Quartal | string | |
| YearQuarter | Jahr-Quartal | string | |
| QuarterDisplayLong | Quartal (lang) | string | |
| QuarterDisplayShort | Quartal (kurz) | string | |
| Month | Monat | int64 | |
| MonthDisplay | Monat (display) | string | |
| MonthDisplayLong | Monat (lang) | string | |
| MonthDate | Monat (Datum) | dateTime | |
| YearMonth | Jahr-Monat | string | |
| Week | Woche | int64 | |
| WeekDisplay | Woche (display) | string | |
| YearWeekDisplay | Jahr-Woche (display) | string | |
| ISO_Week | ISO Woche | int64 | |
| ISO_WeekDisplay | ISO Woche (display) | string | |
| DayOfMonth | Tag im Monat | int64 | |
| DayOfYear | Tag im Jahr | int64 | |
| Weekday | Wochentag | int64 | |
| WeekdayDisplay | Wochentag (display) | string | |
| WeekdayDisplayLong | Wochentag (lang) | string | |
| FY_DateBusinessKey | Datum (Fiskaljahr) | dateTime | |
| CurrentDate | Aktuelles Datum | int64 | |
| CurrentMonth | Aktueller Monat | int64 | |
| PrevMonth | Vormonat | int64 | |
| CurrentYear | Aktuelles Jahr | int64 | |
| WeekStartDate | WeekStartDate | dateTime | |
| DayOffset | DayOffset | int64 | |
| MonthOffset | MonthOffset | int64 | |
| YearOffset | YearOffset | int64 | |
| IsLastDateOfMonth | IsLastDateOfMonth | int64 |