cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vmkumar1 Frequent Visitor
Frequent Visitor

IF logical Fucntion

Hi All,

 

I am new to DAX coding. Could you please help me in understanding below function? Thanks .

 

I am using a IF(OR( Column1 = "X","Y","A","B")) logic in excel to compare my column1 values.

When I tried the same logic in PowerBi measure, I wont see my column name at all, IF(OR())

Could you please help me by explaining what am I mssing here? Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: IF logical Fucntion

 

Here is the syntax for IF with multiple values . Hope this helps to you.

 

Column = IF(Detais[Category] IN {"AA", "AB","BA"} , 1,2)
 
Thanks
Raj
2 REPLIES 2
Highlighted
Super User
Super User

Re: IF logical Fucntion

 

Here is the syntax for IF with multiple values . Hope this helps to you.

 

Column = IF(Detais[Category] IN {"AA", "AB","BA"} , 1,2)
 
Thanks
Raj
vmkumar1 Frequent Visitor
Frequent Visitor

Re: IF logical Fucntion

Thanks for the reply Rajendran.

When to use a Measure or Conditional Coulumn?

Do u mind helping me to undersatnd when to use Calculate or Filter function?