How to use if function

[Anonymous]

Hi everyone, may i know how can I code based on the below example 

In my table, if the code that start with 'GAC' or 'KKKK',  it should be put as 'Contract' at the right column, else Non-contract

thank you. 

Best regard

[Samarth_18 · Accepted solution]

Hi @Anonymous ,

You could create a column as below:-

Group = 
var _start_with  = MID('Table'[Code],1,4)
return IF(CONTAINSSTRING(_start_with,"GAC") || CONTAINSSTRING(_start_with,"KKKK"),"Contract","Non Contract")

BR,

Samarth

[Anonymous]

Hi, thank you so much ! it works from my side.