If & Today operators

[andrewb95]

I am attempting to run a query so a new column will populate as TRUE if two statuses from one column are correct and the date is before the current date. 

ie. I have: 
A database where each contact can match one of the following items and has association with a date. 

Column A:
Item 1 | Item 2 | Item 3 | Item 4 | Item 5

Column B:

A list of dates 

I want to say IF Column A = Item 1 or Item 2 AND Column B date is before TODAY. Then Equal to True, if not equal to false. 

[amitchandak]

@andrewb95 , Are these columns or table. If tables what is relation. Can share some sample data and explain with example

[andrewb95]

It was all from columns within the same table, many thanks for attempting to support. 

[Fowmy]

@andrewb95 

Try below code as  new column

STATUS = 
IF((Table1[COLUMNA] = "ITEM-1" || [Direction] = "ITEM-2" || )&& Table1[COLUMNB] < TODAY() ,TRUE(), FALSE())

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube, LinkedIn 

[andrewb95 · Accepted solution]

This worked however not all the parenthesis were needed:

IF(Table1[COLUMNA] = "ITEM-1" || [Direction] = "ITEM-2" || && Table1[COLUMNB] < TODAY() ,TRUE(), FALSE())

Thanks!