Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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....
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

     

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

 

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

    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?