Forum Discussion

tempranello's avatar
tempranello
Icon for Advocate I rankAdvocate I
10 years ago
Solved

Test for a number

Hi there   I must be losing it...this seems such a simple thing to do, but I'm blowed if I can sort this out myself.   I've a column of type text in a query that may or may not contain text or a ...
  • chrisu's avatar
    chrisu
    10 years ago

    I think you want to use Value.Is.  To check if a value is text, it would look something like this:

     

    Value.Is([Column],type text)

     

    To check for a number, it would be:

     

    Value.Is([Column], Int64.Type)

     

    Value.Is returns a boolean true/false, so you can wrap it in an IF.  

  • Anonymous's avatar
    Anonymous
    8 years ago

    Worked for me. Thank you!

     

    if Value.Is(AlphaNumeric, type text) then AlphaNumeric else Number.ToText(AlphaNumeric))
wonga's avatar
wonga
Icon for Continued Contributor rankContinued Contributor
10 years ago

Are you trying to do this through DAX or Power Query?

 

DAX is used for Measures and Power Query is used for Calculated Columns.

  • tempranello's avatar
    tempranello
    Icon for Advocate I rankAdvocate I
    10 years ago

    Apologies, I'm doing this in Power Query.

    • wonga's avatar
      wonga
      Icon for Continued Contributor rankContinued Contributor
      10 years ago

      Can you provide some more context as to what you want to achieve? Provide a sample dataset and what you want the expected result to be.