Dax Measure Calculating last Years Week Num as well as this years

[cooksteve09]

How can i stop my dax from counting last years week number and only look at 2022 please

Last Week Offers =
VAR _LastWeekOffers =

CALCULATE(
COUNTA(Offers[Offer_Initiative.Initiative_Title]),
Dates[Week Num]= WEEKNUM(TODAY(),1)-1)
RETURN
IF(ISBLANK(_LastWeekOffers),0,_LastWeekOffers)

[amitchandak · Accepted solution]

@cooksteve09 , Try like

Last Week Offers =
VAR _LastWeekOffers =

CALCULATE(
COUNTA(Offers[Offer_Initiative.Initiative_Title]), filter(Dates,
Dates[Week Num]= WEEKNUM(TODAY(),1)-1 && year(Dates[Date]) = year(Today())))
RETURN
IF(ISBLANK(_LastWeekOffers),0,_LastWeekOffers)

also, refer the rank way

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8

[cooksteve09]

Thank you very much, just couldnt get it myself!

Appreciate that