Calculated column to measure

[CarlsBerg999]

Hi, 

I managed to create what i want as a calculated column, but im lost on why this doesnt work as a measure:

Current Week =

IF(

AND(DateTable[WeekNumber] = WEEKNUM(TODAY())-1,

DateTable[Year]=YEAR(TODAY())),

TRUE, FALSE)

How do i turn the DAX above to a measure and why doesnt IF work in measures?

Thanks for the help! 

[amitchandak · Accepted solution]

@CarlsBerg999 , a measure will be like

Current Week =
IF(
AND(max(DateTable[WeekNumber]) = WEEKNUM(TODAY())-1,
max(DateTable[Year])=YEAR(TODAY())),
TRUE, FALSE)

refer in case you are looking for WOW

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