I am trying the following formula but it gets me nowhere.
What I want to achieve, is to get a list of the rows in the X data set that comply with 2 conditions.
- Date in Date column is equal to current Week.
- Name in Name column of X data set is equal to Name column in current data set.
([Date] = WEEKNUM(today())),
([Name] = [_THISROW].[Name])
I also tried
(EOWEEK(TODAY()) - 6)),
Thank you in advance