Forum Discussion
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 ca...
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!!!
Hi
Create a new new column and use the following Dax Query
Result =
IF (
NOT (
ISERROR (
VALUE ( 'Table'[Answer] )
)
),
VALUE ( 'Table'[Answer] )
)
IF (
NOT (
ISERROR (
VALUE ( 'Table'[Answer] )
)
),
VALUE ( 'Table'[Answer] )
)
If this post helps ,Accept is as a Solution.
Kudos helps too!!!