A calendar table that contains a list of dates broken down by days, months, working/non-working days, and country. It is used as a calendar reference in Power BI for aggregations and date filtering.
| Field Name | Description |
|---|---|
calendar_actual | A text label that indicates whether the record belongs to the current month. If the month of the date = the current month, then the value = Actual. In other cases — NULL. |
calendar_date_day | Full date in the format: day of the week, day, month, year (equal to datefrom). This is the actual calendar day. |
calendar_month | The first day of the month in the format: day of the week, 1 day, month, year. Used for grouping data by months. |
Day | Date in the format hh:mm:ss. |
key_calendar_day | Date in the format: day of the week, day, month, year. |
month number | Month number |