Holidays


Controls how to generate an Holidays table used to identify holidays in a Date table.

IsoCountry

Two-letter ISO code of the country to use. The holidays are retrieved for a single country from the HolidaysDefinition table.

InLieuOfPrefix

Prefix of holiday name generated by “in lieu of” algorithm.

InLieuOfSuffix

Suffix of holiday name generated by “in lieu of” algorithm.

HolidaysDefinitionTable

Name of the table generated by the HolidaysDefinition template containing the definition of the holidays for the supported countries.

WorkingDays

String expression that returns a DAX table with one column and as many rows as the number of working days. The weekdays are expressed by integer numbers where Sunday is 1. For example, to specify Monday to Friday as working days use the following table constructor:

{ 2, 3, 4, 5, 6 }
Last update: Oct 13, 2024