Type.Is

This function checks whether a value of type1 can be used with type2 without any compatibility issues.

Assess whether a numeric value can always be interpreted as any data type in Power Query M using the function Type.Is. Example 1: Type.Is(type number, type any) will output true if the numeric value can always be treated as any data type. Example 2: Type.Is(type any, type number) will output false if the value of any data type cannot always be treated as a number.