Archive

XIRR

Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.

XNPV

Returns the present value for a schedule of cash flows that is not necessarily periodic.

SqlExpression.ToExpression

Syntax SqlExpression.ToExpression(sql as text, environment as record) as text Description SqlExpression.ToExpression Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Value Functions / SqlExpression.ToExpression

Value.As

Syntax Value.As(value as any, type as type) as any Description Value.As Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Value Functions / Value.As

Value.Add

Syntax Value.Add(value1 as any, value2 as any, optional precision as nullable number) as any Description Returns the sum of value1 and value2. An optional precision parameter may be specified, by default Precision.Double is used. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Value Functions /… Read More »Value.Add

Precision.Double

Syntax null Description An optional parameter for the built-in arithmetic operators to specify double precision. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Value Functions / Precision.Double

Value.ReplaceMetadata

Syntax Value.ReplaceMetadata(value as any, metaValue as any) as any Description Replaces the input’s metadata information. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Value Functions / Value.ReplaceMetadata

Value.Equals

Syntax Value.Equals(value1 as any, value2 as any, optional precision as nullable number) as logical Description Returns true if value value1 is equal to value value2, false otherwise. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Value Functions / Value.Equals