Forum Discussion
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
thank you.
Best regard
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
2 Replies
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