I have a column with text, positive and negative numbers. How can I split these values in PowerBI

[treesa2010]

I have a column with text, postive and negative numbers. How can I split these values in PowerBI?

Can you please help.

[treesa2010]

Thanks @VahidDM

[VahidDM · Accepted solution]

Hi @treesa2010 

Try these codes to add custom columns with DAX:

negative = 
Var _V = IFERROR(CONVERT('Table'[Values],INTEGER),BLANK())
return
if(_V<0,'Table'[Values],blank())

Postive = 
Var _V = IFERROR(CONVERT('Table'[Values],INTEGER),BLANK())
return
if(_V>0,'Table'[Values],blank())

Text = 
Var _V = IFERROR(CONVERT('Table'[Values],INTEGER),BLANK())
return
if(ISBLANK(_V),'Table'[Values],blank())

output:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/