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 how to do this in the data table - create column.

Thanks !

  • 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

2 Replies

  • 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