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


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


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


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


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


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 0. For example, to specify Monday to Friday as working days use the following table constructor:

{ 2, 3, 4, 5, 6 }
Last update: May 26, 2024