Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 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
    6 years ago

    Anonymous 

    like what CNENFRNL  suggested, you can try

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