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

powerquery
will picture will · Jun 22, 2016 · Viewed 30.6k times · Source

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?

Answer

Vikas Gautam picture Vikas Gautam · Sep 28, 2016

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!

Related questions

Difference between PowerPivot, PowerQuery and PowerBI

What is the difference between PowerPivot, PowerQuery and PowerBI? How should one decided which tool should be used and when.

Read More
Convert matrix to 3-column table ('reverse pivot', 'unpivot', 'flatten', 'normalize')

I need to convert the Excel matrix FIRST in the table LATER: FIRST: P1 P2 P3 P4 F1 X F2 X X F3 X X F4 X X LATER: F P VALUE F1 P1 X F1 P2 F1 P3 F1 …

Read More
How can I reference a cell's value in PowerQuery

I'm having multiple PowerQuery queries that I would like to feed the value of a cell in my Excel file. In this particular case, the full path to the sourcefile name. Is there any way I can get this into …

Read More