Forum Discussion

granade1's avatar
granade1
Frequent Visitor
6 years ago
Solved

Data Table View - If Else statement based on data in 2 columns

  In data table (I can do this in edit queries) I need an IF ELSE statement that looks at these two columns and; IF NoTE = 1 and LastUpdate2Days = False then TRUE Else FALSE   I can't figure out...
  • Pragati11's avatar
    Pragati11
    6 years ago

    Hi granade1 ,

     

    You can create a column using DAX as follows:

     

    IF(Table1[Note] = 1 && Table1[LastUpdate2Days] = "False", "TRUE", "FALSE")

     

    NOTE: Replace "Table1" in the above DAX with your table name

     

    If the answer is useful please give Kudos or mark it as a solution if this works! 🙂

     

    Thanks,

    Pragati

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

Hi granade1 ,

 

You can create a column using DAX as follows:

 

IF(Table1[Note] = 1 && Table1[LastUpdate2Days] = "False", "TRUE", "FALSE")

 

NOTE: Replace "Table1" in the above DAX with your table name

 

If the answer is useful please give Kudos or mark it as a solution if this works! 🙂

 

Thanks,

Pragati