Help with WEEKNUM DAX

[Guttmann1983]

Hi, I am trying to figure out where I am going wrong with the below formula

=IF(WEEKNUM([Demand Sent]=WEEKNUM(TODAY()-1),2,"Last Week",""))

I am trying to just return "Last Week" if the date in column "Demand Sent" was from last week (Mon-Sun)

 

[Guttmann1983]

Edit to this ---

I also need to check if the year of the date in column Demand Sent is the current year as well...

 

[Nick Chobotar]

Hello,

Here is the correct formula for your calculated column

=
IF (
WEEKNUM ( Table1[Demand Sent] )
= WEEKNUM ( TODAY () ) - 1,
"Last Week",
""
)






Thanks, Nick -

 

[Nick Chobotar]

This one with a condition checking for current year

Nick -


=
IF (
WEEKNUM ( Table1[Demand Sent] )
= WEEKNUM ( TODAY () ) - 1
&& YEAR ( Table1[Demand Sent] ) = YEAR ( TODAY () ),
"Last Week",
""
)