Like function

[muhie]

Hi there 

Please can someone help me with my statement. Im using a like but im getting an error on my like 

Below is my statement 

if [strSerialNumber] like '%ZF%' then [Line Total Incl]*[ZF Split]/100 else [Line Total Incl] * [All Split]\100 

Thanks 

Muhie 

[v-qiuyu-msft · Accepted solution]

Hi @muhie,

Assume you want to use DAX, you can create a calculated column like below: 

Column 2 = IF(SEARCH("ZF",Table1[strSerialNumber] ,1,0),Table1[Line Total Incl]*Table1[ZF Split]/100,Table1[Line Total Incl]*Table1[All Split]/100)

Best Regards,
Qiuyun Yu