powerquery

Is there an ISNUMBER() or ISTEXT() equivalent for Power Query?

I have a column with mixed types of Number and Text and am trying to separate them into different columns using an if ... then ... else conditional. Is there an ISNUMBER() or ISTEXT equivalent for power query?

Solution

  • Here is how to check type in Excel Powerquery

    IsNumber =Value.Is(Value.FromText([ColumnOfMixedValues]), type number)

    IsText =Value.Is(Value.FromText([ColumnOfMixedValues]), type text)

    hope it helps!