Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Conditional column for alphabet and number

How to create a conditional column in Power query, that show "Text" if the column has alphnumeric while "Number" if the the column has value only? Thank you
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    Then use the formula posted earlier

    = try if Value.Is(Number.FromText([Data]), type number) then "Number" else "Text" otherwise "Text"

     

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

Then use the formula posted earlier

= try if Value.Is(Number.FromText([Data]), type number) then "Number" else "Text" otherwise "Text"

 

slschmidt's avatar
slschmidt
Frequent Visitor
3 years ago

Can you create a calculated column instead of doing it in power query?  My data source is in direct query mode and I can't create a custom column.  I want to do this same exact thing though.