topic Re: How to use if function in DAX Commands and Tips

How to use if function

Anonymous — Wed, 08 Jun 2022 03:54:44 GMT

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

Re: How to use if function

Samarth_18 — Wed, 08 Jun 2022 05:17:54 GMT

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

Re: How to use if function

Anonymous — Mon, 13 Jun 2022 07:29:12 GMT

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