Value.Optimize

Updated on

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.

Other functions related to Value.Optimize are:

BI Gorilla Blog

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