Share via

Type.Is

  • Article

Syntax

Type.Is(type1 as type, type2 as type) as logical

About

Determines if a value of type1 is always compatible with type2. Parameter type2 should be a primitive (or nullable primitive) type value. Otherwise, this function's behavior is undefined and shouldn't be relied on.

Example 1

Determine if a value of type number can always also be treated as type any.

Usage

Power Query M 
Type.Is(type number, type any)

Output

true

Example 2

Determine if a value of type any can always also be treated as type number.

Usage

Power Query M 
Type.Is(type any, type number)

Output

false

Related content