Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to use if function

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 t...
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    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

     

Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

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