Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Add column to extract Numbers from Text column

I have a table as show below

I want to retrieve all number from the Answer column and the expected result as shown below

The Result column can help me to sum number of Attendee.

How can I acheive this either in power query or DAX

Any help will be appreciated.

 

 

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi

    Create a new new column and use the following Dax Query

    Result =
    IF (
    NOT (
    ISERROR (
    VALUE ( 'Table'[Answer] )
    )
    ),
    VALUE ( 'Table'[Answer] )
    )
     
     
    If this post helps ,Accept is as a Solution.
    Kudos helps too!!!

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi

    Create a new new column and use the following Dax Query

    Result =
    IF (
    NOT (
    ISERROR (
    VALUE ( 'Table'[Answer] )
    )
    ),
    VALUE ( 'Table'[Answer] )
    )
     
     
    If this post helps ,Accept is as a Solution.
    Kudos helps too!!!