Value.Alternates

Updated on

Value.Alternates is a Power Query M function intended for expressing alternate query plans within a query plan expression obtained through Value.Expression(Value.Optimize(…)). The function is not intended for other uses.

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

Syntax

Value.Alternates( alternates as list ) as any

Description

Expresses alternate query plans within a query plan expression obtained through Value.Expression(Value.Optimize(…)). Not intended for other uses.

Other functions related to Value.Alternates are:

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