Day.Type

Updated on

Day.Type specifies a day of week.

Enumeration Options

Enumerations simplify the process of selecting options within a function. To specify the Day.Type, users have the option to either input the below Argument description (which provides more information) or the shorter Value (which provides a more concise representation).

ArgumentValueDescription
Day.Sunday0Represents Sunday.
Day.Monday1Represents Monday.
Day.Tuesday2Represents Tuesday.
Day.Wednesday3Represents Wednesday.
Day.Thursday4Represents Thursday.
Day.Friday5Represents Friday.
Day.Saturday6Represents Saturday.

Applies to

Here’s a list of functions that work with Day.Type:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/day-type