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

Last update: August 17, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/value-optimize
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.