Power Pivot new column or measure - IF(ISNUMBER(SEARCH("Excel",$A2)),"X","")

[Tamaradownunder]

Please help....

I have an column which contains combined data, and I am trying to add a new column for each item in the combined column

Column B contains a list of SW licenses assigned to individuals (column A) and I am trying to add columns C,D,E & F via Power Pivot as a new column or a measure
(each can cell contain from 0 to 25 difference licenses, in no particular order)

The excel Formula I would normally use is
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]

						[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]IF(ISNUMBER(SEARCH(C$2,$A2)),"X","") or [/FONT][FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]IF(ISNUMBER(SEARCH("Excel",$A2)),"X","") However I can't get it to work in Power Pivot as a new column or measure[/FONT]
						Person License Adobe Word Excel Project Tom Adobe + Word X X Lisa Mary Excel +Word + Project X X X Bob Project + Word X X John Word + Adobe, Excel + Project X X X X <tbody> </tbody> <strike></strike>
						<colgroup><col><col><col><col span="4"></colgroup><tbody> </tbody> <colgroup><col><col><col><col span="4"></colgroup><tbody> </tbody>

<colgroup><col><col><col><col span="4"></colgroup><tbody>
</tbody>

<strike></strike><strike></strike>


[/FONT]