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.
FILTER(
โXโ,
AND(
([Date] = WEEKNUM(today())),
([Name] = [_THISROW].[Name])
)
)
I also tried
(EOWEEK(TODAY()) - 6)),
Thank you in advance
[Date], is, presumably, a Date type value. WEEKNUM() outputs a Number type value. For any equality, you must compare a data type against the same data type. I suspect you want this:
WEEKNUM( [Date] ) = WEEKNUM( TODAY() )
Worked perfectly! Thank you very much!
User | Count |
---|---|
41 | |
31 | |
31 | |
16 | |
14 |