topic Re: Data Table View - If Else statement based on data in 2 columns in DAX Commands and Tips

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

granade1 — Wed, 19 Feb 2020 18:00:51 GMT

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 !

granade1 — Wed, 19 Feb 2020 18:01:18 GMT

Pragati11 — Thu, 20 Feb 2020 14:56:31 GMT

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