Archive

Syntax null Description Returns 1, the number representing Sunday. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Date Functions / Day.Sunday

Syntax Date.IsInNextQuarter(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the next quarter, as determined by the current date and time on the system. Note that this function will return false when passed a value that occurs within… Read More »Date.IsInNextQuarter

Syntax Date.IsInCurrentWeek(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the current week, as determined by the current date and time on the system. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Date Functions / Date.IsInCurrentWeek

Syntax Date.DayOfWeek(dateTime as any, optional firstDayOfWeek as nullable number) as nullable number Description Returns a number (from 0 to 6) indicating the day of the week of the provided dateTime. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Date Functions / Date.DayOfWeek

Syntax Date.FromText(text as nullable text, optional culture as nullable text) as nullable date Description Creates a date value from a textual representation, text, following ISO 8601 format standard. An optional culture may also be provided (for example, “en-US”). Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions… Read More »Date.FromText

Syntax Date.From(value as any, optional culture as nullable text) as nullable date Description Returns a date value from the given value. An optional culture may also be provided (for example, “en-US”). If the given value is null, Date.From returns null. If the given value is… Read More »Date.From

Syntax Date.AddDays(dateTime as any, numberOfDays as number) as any Description Returns the date, datetime, or datetimezone result from adding numberOfDays days to the datetime value dateTime. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Date Functions / Date.AddDays

Syntax Date.QuarterOfYear(dateTime as any) as nullable number Description Returns a number from 1 to 4 indicating which quarter of the year the date dateTime falls in. dateTime can be a date, datetime, or datetimezone value. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Date Functions… Read More »Date.QuarterOfYear

Syntax Date.IsInCurrentYear(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the current year, as determined by the current date and time on the system. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Date Functions / Date.IsInCurrentYear

Syntax Date.StartOfQuarter(dateTime as any) as any Description Returns the first value of the quarter