Archive

Diagnostics.Trace

Syntax Diagnostics.Trace(traceLevel as number, message as anynonnull, value as any, optional delayed as nullable logical) as any Description Writes a trace message, if tracing is enabled, and returns value. An optional parameter delayed specifies whether to delay the evaluation of value until the message is… Read More »Diagnostics.Trace

TraceLevel.Warning

Syntax null Description Returns 3, the value for Warning trace level. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Error Handling Functions / TraceLevel.Warning

TraceLevel.Critical

Syntax null Description Returns 1, the value for Critical trace level. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Error Handling Functions / TraceLevel.Critical

TraceLevel.Verbose

Syntax null Description Returns 5, the value for Verbose trace level. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Error Handling Functions / TraceLevel.Verbose

TraceLevel.Information

Syntax null Description Returns 4, the value for Information trace level. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Error Handling Functions / TraceLevel.Information

Duration.TotalSeconds

Syntax Duration.TotalSeconds(duration as nullable duration) as nullable number Description Returns the total seconds spanned by the provided duration value, duration. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Duration Functions / Duration.TotalSeconds

Duration.From

Syntax Duration.From(value as any) as nullable duration Description Returns a duration value from the given value. If the given value is null, Duration.From returns null. If the given value is duration, value is returned. Values of the following types can be converted to a duration… Read More »Duration.From

Duration.TotalHours

Syntax Duration.TotalHours(duration as nullable duration) as nullable number Description Returns the total hours spanned by the provided duration value, duration. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Duration Functions / Duration.TotalHours

#duration

Syntax #duration(days as number, hours as number, minutes as number, seconds as number) as duration Description Creates a duration value from numbers days days, hours hours, minutes minutes, and seconds seconds. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Duration Functions / #duration

Duration.TotalDays

Syntax Duration.TotalDays(duration as nullable duration) as nullable number Description Returns the total days spanned by the provided duration value, duration. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Duration Functions / Duration.TotalDays