Date configuration can be managed by stepping through the Fenwick Gold Assisted Setup for Power BI, or by navigating to the Fenwick Gold Setup for Power BI page.
Four components need to be configured:
Calendar Type
Fenwick Gold for Power BI supports three calendar types:
Standard Calendar Configuration
Standard Calendar: 12-month calendar that begins on January 1 and ends on December 31.
| Field Name | Description |
|---|---|
| First Day of Week | Defines the first day of a week. US calendars typically use Sunday, whereas European calendars use Monday. |
| Iso Country Holiday | Defines which country to use in order to set the holidays in the calendar as non-working days. |
Fiscal Year Calendar Configuration
Fiscal Year: 12-month calendar starting from a month other than January.
| Field Name | Description |
|---|---|
| First Month of Fiscal Year | Defines the first month of the Fiscal calendar. If set to 1, the fiscal monthly calendar is identical to the standard calendar. |
| First Day of Week | Defines the first day of a week. US calendars typically use Sunday, whereas European calendars use Monday. |
| Iso Country Holiday | Defines which country to use in order to set the holidays in the calendar as non-working days. |
Week Based Calendar Configuration
Weekly: Calendar that supports: 445, 454, or 544 week groupings.
| Field Name | Description |
|---|---|
| First Month of Fiscal Year | Defines the starting period for the Fiscal Weekly calendar. |
| First Day of Week | Defines the first day of a week and defines when a week starts in the Fiscal Weekly calendar. US calendars typically start on Sunday, whereas European calendars start on Monday. |
| Iso Country Holiday | Defines which country to use in order to set the holidays in the calendar as non-working days. |
| Week Type | Determines the end of the year definition for the Fiscal Weekly calendar. – Last: Last weekday of the month at Fiscal year end. – Nearest: Last weekday nearest the end of month. |
| Quarter Week Type | Defines the number of weeks per period in each quarter. Quarters which always count 13 weeks in the Fiscal Weekly calendar. – 445 – 454 – 544 |
UTC Offset
The UTC Offset allows your Power BI semantic model to accurately calculate what the current day is in respect to your geographical location. This is necessary because Microsoft’s servers may be hosting your Power BI Service from a data center located in a different region.
UTC offsets are based on Business Central time zones.
Date Table Range
The Starting Date and Ending Date fields are set automatically based on your Business Central Accounting Periods. Based on these dates, Power BI will generate a series of continuous dates for your date table. If you have Budgets that extend past the last date in your Account Period table, you will need to manually set the Ending Date to accommodate the extended range.
Working Days
Defines the working days of the week. The default setting is Monday to Friday.
