Forum Discussion
Helper IIIf & Today operators
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.
This worked however not all the parenthesis were needed:
IF(Table1[COLUMNA] = "ITEM-1" || [Direction] = "ITEM-2" || && Table1[COLUMNB] < TODAY() ,TRUE(), FALSE())
Thanks!
4 Replies
- Fowmy
Super User
andrewb95
Try below code as new columnSTATUS = 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 🙂
andrewb95This worked however not all the parenthesis were needed:
IF(Table1[COLUMNA] = "ITEM-1" || [Direction] = "ITEM-2" || && Table1[COLUMNB] < TODAY() ,TRUE(), FALSE())
Thanks!
- 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.
