Value.Optimize

Value.Optimize is a Power Query M function that, when used within Value.Expression, indicates that the optimized expression should be returned if the input value represents a query that can be optimized. The function returns the optimized expression or the input value with no effect.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

Value.Optimize( value as any ) as any

Description

When used within Value.Expression, if value represents a query that can be optimized, this function indicates that the optimized expression should be returned. Otherwise, value will be passed through with no effect.

Related functions

Other functions related to Value.Optimize are:

• Value.Compare
• Value.Equals
• Value.NativeQuery
• Value.NullableEquals

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/value-optimize