Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Is there an ISNUMBER() or ISTEXT() equivalent in Power Query

Hi Folks, While data cleaning using the power query, I came across a situation where a column contains both text and numerical values. I want to add an additional column that states which one is num...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    Anonymous 

    like what CNENFRNL  suggested, you can try

    if Value.Is([data],type number) 
then "Number"
else "Text"

     

QooT's avatar
QooT
Frequent Visitor
3 years ago

Hi,
It is not working when you have column type text - then results is always Text,
It works when you first get valuefrom text, and then check type.

Value.Is(Value.FromText([data]), type number))
MartinZima's avatar
MartinZima
New Member
3 years ago

Thanks QooT,

I was having this issue and even though my column data type was "Any", for whatever when PowerQuery parsed in the data everything became a string, so even values of 123 were resulting in Text, however your adjustment to the formula fixed this, so thanks!

 

 

IsNumber
--------
= if Value.Is(Value.FromText([--column-name-here--]), type number)
then "Y"
else "N"