Split the result

[akhmad_danial]

Hi,

Is it possible that I can split the result for the result of "G" and "M" in the Serology test? 

this is my table

and my data 

Any guidance to solve this?

I've tried to split the column in the result for G and M but only G and M are shown, but for the result of PCR and Antigen is blank.

Thank you in advance

[v-yiruan-msft]

Hi @akhmad_danial ，

What's your expected result? Whether the below screenshot is what you want? Please provide your expected result with special example or screenshot. Thank you.

You can also refer to the following blogs split result column:

How to Split Columns in Power BI

How to Split Cells and Text in Excel with Power Query

Split a column of text (Power Query)

Best Regards

[Anonymous · Accepted solution]

@akhmad_danial Try something like this:

result measure=

IF([Type]="Serology",

IF([detail]="G",LEFT([result],SEARCH(",".[result])-1),RIGHT([result],LEN([result])-SEARCH(",".[result]))

), [result]

)

[akhmad_danial]

Great, Thanks @Anonymous .

The results are in accordance with what I expected, like this:

It's just that takes a long time to process if the data is big. Another alternative, I split column result in table screening result into 2 columns, to find "G" and "M" value first, after that create a measure.