DAX Extract values from column

[MarkCBB]

Hi there,

I am fairly new to DAX, I have a table called RB and a column called Answers, the answer column has numeric and Alpha entries, I need to add 2 new columns, the one has the extaced numeric answers and the other has the extracted Alpha answers.

Can someone assist me with the correct DAX to do the above?

Look forward to the help.

 

[MarkCBB]

Hi there,

Just to follow on from the above, I found another way to do this (I am sure there is a better way). I duplicated the Answer Column and change the format of the one to whole number and the other to text and this seems to have solved the challenge.

I am still interested in seeing what other ways there are to do this.

Thank you

 

[PentaGalCXO]

NumericColumn=if(isnumber([answer]),[answer],blank()) //then type the column as number
AlphaColmn=if(isnumber([answer]),blank(),[answer]) //then type the column as text

Depending on what values you encounter, you may need to encapsulate the above with iferror()

 

[MarkCBB]

Hi PentaGalCXO,

Am I correct in assuming that this needs to be done in the Power BI window and not in the PQ window? (when I try your formula in the PQ Editor window. I get syntax errors. (PQ Editor > Add Column > Add Custom Column