Split comma separated values in column and add it in a new column

I have a table where I created a measure SourceOrderTag which can have 2 values as you can see in the table

07e34be8-467f-4f73-8f61-c3f9a5f656fc.png

The order of data coming in the column is not fix.

I want to take the Drop Order from both rows and put it in the Source column & DRTV - Warranty Replacement in Order_tag column

To do that I wrote this expression - 

case(when(count(split(${sourceordertag},",")) = 2,index(split(${sourceordertag},","),1)),null)

Using this expression the split is happening but its not exactly giving me the result I want.

Can anybody please help??

1 1 1,263
1 REPLY 1
Top Labels in this Space