Help with: REF_ROWS with IFS or SELECT

[Michelle_Digi]

Hi,

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.

1. Date in Date column is equal to current Week.
2. Name in Name column of X data set is equal to Name column in current data set.

FILTER(
“X”,
AND(
([Date] = WEEKNUM(today())),
([Name] = [_THISROW].[Name])
)
)

I also tried

(EOWEEK(TODAY()) - 6)),

Thank you in advance