Syntax Date.StartOfMonth(dateTime as any) as any Description Returns the first value of the month given a date or datetime type. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Date Functions / Date.StartOfMonth
Syntax Date.IsInPreviousNQuarters(dateTime as any, quarters as number) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the previous number of quarters, as determined by the current date and time on the system. Note that this function will return false when passed… Read More »Date.IsInPreviousNQuarters
Syntax Date.MonthName(date as any, optional culture as nullable text) as nullable text Description Returns the name of the month component for the provided date. 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 / Date Functions /… Read More »Date.MonthName
Syntax Date.AddYears(dateTime as any, numberOfYears as number) as any Description Returns the date, datetime, or datetimezone result of adding numberOfYears to a 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.AddYears
Syntax Date.IsInPreviousNDays(dateTime as any, days as number) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the previous number of days, as determined by the current date and time on the system. Note that this function will return false when passed… Read More »Date.IsInPreviousNDays
Syntax Date.IsInNextNYears(dateTime as any, years as number) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the next number of years, as determined by the current date and time on the system. Note that this function will return false when passed… Read More »Date.IsInNextNYears
Syntax Date.Day(dateTime as any) as nullable number Description Returns the day component of 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 / Date.Day
Syntax Date.IsInNextNMonths(dateTime as any, months as number) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the next number of months, as determined by the current date and time on the system. Note that this function will return false when passed… Read More »Date.IsInNextNMonths
Syntax null Description Returns 3, the number representing Tuesday. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Date Functions / Day.Tuesday
Syntax Date.IsInCurrentMonth(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the current month, 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.IsInCurrentMonth