Skip to content

Releases: sql-bi/DaxDateTemplate

Specify first and last year for each holiday

30 Nov 22:45
093e75c
Compare
Choose a tag to compare

Each holiday has a first and last date, use 0 to define no boundaries.

Added holidays for Austria, Norway, and Juneteenth in US

29 Nov 08:50
b7a5d73
Compare
Choose a tag to compare

Added holidays for Austria
Added holidays for Norway
Added Juneteenth holiday in US with additional setting for "in lieu" holiday before/after weekend
Fixed RelativePos columns (negative/positive were inverted compared to documentation)
Data type changed to Date instead of Date/Time for Power BI (internal is always DateTime, this is just additional metadata only for Power BI)
Fixed small typos in comments

Added OffsetDays argument to Holidays table

02 Mar 19:19
36ee8d8
Compare
Choose a tag to compare

Added OffsetDays argument to Holidays table in order to fix an issue in computing Black Friday and similar events that are after another relative date.
v1.13 (Jan 19, 2020)
Fixed bug in Fiscal YearDays column when the first month of the fiscal year was set to January.

Bug fixes

22 Dec 10:03
9156aa4
Compare
Choose a tag to compare

Fixed bug in computing week number when the fiscal year was starting in January. (1.08)
Fixed bug in definition of the year of fiscal week calendar. (1.10)
Fixed bug in Calendar Month column that was not sorted correctly. (1.11)
Fixed bug in Fiscal Year settings.
Fixed bug in range of dates generated when starting fiscal month is January.

Fixed minor issue in holidays for Sweden

31 Dec 10:26
630fa2a
Compare
Choose a tag to compare

Fixed date for Boxing Day in Swedish holidays.

Bug fixes in holidays and added Swedish holidays

28 Dec 09:44
53a757e
Compare
Choose a tag to compare

Added Swedish holidays
In order to support Swedish holidays there is the special calculation of Midsummer Day (Saturday between 20 and 26 June). This is required to compute the Midsummer Eve (the day before) in case it is a holiday.

Fixed SubstituteHoliday setting
The SubstituteHoliday setting in HolidayParameters was not working correctly because of a regression introduced in a previous update. For example, this was affecting AU holidays.

Fixed bugs and added FW Period attribute

24 Dec 17:40
aa547d0
Compare
Choose a tag to compare

Fixed bugs and added 4-week periods to FiscalWeekly calendar.
Fixed additional bug in original 1.06 release.

Fixed bugs and added FW Period attribute

24 Dec 16:01
e36b34a
Compare
Choose a tag to compare

Fixed bugs and added 4-week periods to FiscalWeekly calendar.

Fixed management of multiple holidays in the same date

04 Mar 01:12
61a75c2
Compare
Choose a tag to compare

Fixed management of multiple holidays in the same date (it was happening to AU and other countries).