Column split

[Anonymous]

Hi Community..!!
I want solution for the below problem.

invoice

IP123/456

IP345/123

OP456/345

IP234/234

OP234/567

OP897/345

Please refer the above table.

I wanted to split the column in such away that , text starting with IP should fall in one column and text starting with OP should fall in 2nd column.
Could anyone help me out to achieve this ?

[Fowmy · Accepted solution]

@Anonymous 

If you need a DAX solution then add two columns

IP = 
IF(  LEFT(Table3[invoice],2) = "IP",Table3[invoice] )

OP = 
IF(  LEFT(Table3[invoice],2) = "OP",Table3[invoice] )

[Anonymous]

Thanks @Fowmy 

Its solved my problem.

Regards,

Prasad Patil