Syntax Date.IsInYearToDate(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the current year and is on or before the current day, 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… Read More »Date.IsInYearToDate
Syntax Date.IsInNextNWeeks(dateTime as any, weeks as number) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the next number of weeks, as determined by the current date and time on the system. Note that this function will return false when passed… Read More »Date.IsInNextNWeeks
Syntax Date.AddQuarters(dateTime as any, numberOfQuarters as number) as any Description Returns the date, datetime, or datetimezone result from adding numberOfQuarters quarters 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.AddQuarters
Syntax null Description Returns 6, the number representing Friday. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Date Functions / Day.Friday
Syntax Date.IsInPreviousYear(dateTime as any) as nullable logical Description Indicates whether the given datetime value dateTime occurs during the previous 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.IsInPreviousYear
Syntax Comparer.FromCulture(culture as text, optional ignoreCase as nullable logical) as function Description Returns a comparer function given the culture and a logical value ignoreCase for case sensitivity for the comparison. The default value for ignoreCase is false. The value for culture are well known text… Read More »Comparer.FromCulture
Syntax Comparer.Equals(comparer as function, x as any, y as any) as logical Description Returns a logical value based on the equality check over the two given values, x and y, using the provided comparer. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Comparer Functions /… Read More »Comparer.Equals
Syntax null Description Returns the name of the current culture for the application. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Comparer Functions / Culture.Current
Syntax Comparer.OrdinalIgnoreCase(x as any, y as any) as number Description Returns a case-insensitive comparer function which uses Ordinal rules to compare the provided values x and y. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Comparer Functions / Comparer.OrdinalIgnoreCase
Syntax Comparer.Ordinal(x as any, y as any) as number Description Returns a comparer function which uses Ordinal rules to compare the provided values x and y. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Comparer Functions / Comparer.Ordinal