Determine if two different dates (from two different columns) are in the same week

[Anonymous]

My scenario is pretty simple:    If the dates below fall within the same week, then "0", if not, then the number of DAYS between the two dates.   Due Date is connected to my date table.  

I have two dates for this that are relevant.    Due Date   &   Projected Date

My current code only looks at if the dates are exactly the same.   What I need is to determine whether they are just in the same Week or not.     In the example below, March 01  and  March 03 are within the same week, so the result should be "Yes".  

Is in same Week =

VAR _DueDateWeek = SalesOrdersALL[Due Date]

VAR _ProjectedWeek = SalesOrdersALL[ProjectedDate].[Date]

RETURN

IF(_DueDateWeek = _ProjectedWeek,"Yes","No")

[Anonymous]

I am using a column so it looks like this should work!

[Vera_33 · Accepted solution]

Hi @Anonymous 

Are you doing a DAX Calculated column or measure? Use WEEKNUM?

Is in same Week = 
VAR CurDueWeek=WEEKNUM( 'Table'[Due Date])
VAR CurProjectedWeek=WEEKNUM('Table'[ProjectedDate])
RETURN
IF(CurDueWeek=CurProjectedWeek,"Yes","No")