Hello again.
I'm trying to utilize CountIfs to determine workflow...
=COUNTIFS(Details[Market Combined],[@Market],Details[4225:Year],"=2024",Details[4225:WK],">=16",Details[4225:WK],"<=19")
instead of having to manually change the weeks (Row [4225:WK]), I'd like to just set a date range of 28 days prior to "today()" (basically 4 weeks).
Any advise?
I'm trying to utilize CountIfs to determine workflow...
=COUNTIFS(Details[Market Combined],[@Market],Details[4225:Year],"=2024",Details[4225:WK],">=16",Details[4225:WK],"<=19")
instead of having to manually change the weeks (Row [4225:WK]), I'd like to just set a date range of 28 days prior to "today()" (basically 4 weeks).
Any advise?