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

[granade1]

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 · Accepted solution]

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

[granade1]