Add column to extract Numbers from Text column

[Anonymous]

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.

[Anonymous · Accepted solution]

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!!!