Forum Discussion
granade1
6 years agoFrequent Visitor
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...
- 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
granade1
6 years agoFrequent Visitor