Value.Is

Value.Is is a Power Query M function that determines whether an input value is compatible with the specified type. The function returns a boolean indicating the compatibility between the value and the input type.

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

Syntax

Value.Is(
   value as any,
   type as type,
) as logical

Description

Determines whether a value is compatible with the specified type. This is equivalent to the “is” operator in M, with the exception that it can accept identifier type references such as Number.Type.

Examples

Compare two ways of determining if a number is compatible with type number.

// Output: true
Value.Is( 123, Number.Type ) = ( 123 is number )

Related functions

Other functions related to Value.Is are:

• Value.As
• Value.ReplaceType

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