Forum Discussion

sure19's avatar
sure19
Helper II
6 years ago
Solved

Condition column

Dear All,  I have a column where i have a list of countries,  another column for date and then the values etc.  But for some countries i do not want to show the data after certain month and date.  fo...
conditional
  • ibarrau's avatar
    ibarrau
    6 years ago

    Hi there two ways to ask for more than 1 condition in DAX. You can try both:

    First

     

    IF(
    AND ( Condition1, Condition2 ),
    TRUE(),
    FALSE()
)

     

    Second

     

    IF(
    Condition1 && Condition2,
    TRUE(),
    FALSE()
)

     

     Hope this Helps,

    Regards,

ibarrau's avatar
ibarrau
Super User
6 years ago

Hi there two ways to ask for more than 1 condition in DAX. You can try both:

First

 

IF(
    AND ( Condition1, Condition2 ),
    TRUE(),
    FALSE()
)

 

Second

 

IF(
    Condition1 && Condition2,
    TRUE(),
    FALSE()
)

 

 Hope this Helps,

Regards,

Anonymous's avatar
Anonymous
Not applicable
6 years ago

ibarrau, wanted to bring your attention to the fact that:

IF(
    AND ( Condition1, Condition2 ),
    TRUE(),
    FALSE()
)

is exactly the same as

AND ( Condition1, Condition2 )

The second IF is exactly the same.

 

Therefore there's no point doing what you've suggested. Worse, it's more obscure and harder to understand at a glance than the plain and simple expression on its own.

 

Best

D