Forum Discussion
Split the result
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? ...
Anonymous Try something like this:
result measure=
IF([Type]="Serology",
IF([detail]="G",LEFT([result],SEARCH(",".[result])-1),RIGHT([result],LEN([result])-SEARCH(",".[result]))
), [result]
)
Hi Anonymous ，
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