DAX:Expression in Boolean

[scolino]

I am trying to calculate as sum of the WeeklyPlan column with only data that has a year of 2017 and a specified week num. Below is the formula I am using:

LastWeekPlan = CALCULATE(sum('Weekly'[Weekly Plan]),Weekly[Year]=2017,Weekly[WeekNum]=(WEEKNUM(2/13/2017,1)))

The formula works if I add a stagnant number in the Weekly[WeekNum]=... boolean, but when I add the WEEKNUM expression, the formula doesn not work.  I will eventually be replacing the date with today() expression.

Any ideas why my logic will not work?

[v-jiascu-msft]

@scolino

Hi,

Could you please tell me if your problem is solved? You can mark the right answer to help others if it's convenient for you.

Best Regards!
Dale

[Greg_Deckler · Accepted solution]

Use WEEKNUM(DATE(2017,2,13),1)