Syntax Date.DaysInMonth(dateTime as any) as nullable number Description Returns the number of days in the month in the date, datetime, or datetimezone value dateTime. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Date Functions / Date.DaysInMonth
Syntax Date.IsInNextNDays(dateTime as any, days as number) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the next 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.IsInNextNDays
Syntax Date.EndOfDay(dateTime as any) as any Description Returns a date, datetime, or datetimezone value representing the end of the day in dateTime. Time zone information is preserved. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Date Functions / Date.EndOfDay
Syntax Date.IsInCurrentQuarter(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the current quarter, 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.IsInCurrentQuarter
Syntax Date.WeekOfMonth(dateTime as any, optional firstDayOfWeek as nullable number) as nullable number Description Returns a number from 1 to 5 indicating which week of the year month the date dateTime falls in. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Date Functions / Date.WeekOfMonth
Syntax Date.AddMonths(dateTime as any, numberOfMonths as number) as any Description Returns the date, datetime, or datetimezone result from adding numberOfMonths months 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.AddMonths
Syntax Date.WeekOfYear(dateTime as any, optional firstDayOfWeek as nullable number) as nullable number Description Returns a number from 1 to 54 indicating which week of the year the date, dateTime, falls in. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Date Functions / Date.WeekOfYear
Syntax Date.DayOfYear(dateTime as any) as nullable number Description Returns a number representing the day of the year in the provided date, datetime, or datetimezone value, dateTime. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Date Functions / Date.DayOfYear
Syntax Date.EndOfWeek(dateTime as any, optional firstDayOfWeek as nullable number) as any Description Returns the last day of the week in the provided date, datetime, or datetimezone dateTime. This function takes an optional Day, firstDayOfWeek, to set the first day of the week for this relative… Read More »Date.EndOfWeek
Syntax Date.IsInNextYear(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the next year, 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.IsInNextYear