Forum Discussion
Week inclusion in SamePeriodLastyear
Greg_Deckler Thanks for the tip. I will try it later on.
I found another way that works as well.
weeklysales = calculate([ValueTotalCategory];Filter(ALL('Date');'Date'[CalendarYear]=SELECTEDVALUE('Date'[CalendarYear])-1 && 'Date'[Week]=SELECTEDVALUE('Date'[Week])))
Community ChampionAnonymous - See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008
Greg_Deckler Thanks for the tip. I will try it later on.
I found another way that works as well.
weeklysales = calculate([ValueTotalCategory];Filter(ALL('Date');'Date'[CalendarYear]=SELECTEDVALUE('Date'[CalendarYear])-1 && 'Date'[Week]=SELECTEDVALUE('Date'[Week])))