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

Question

My scenario is pretty simple:&nbsp; &nbsp; If the dates below fall within the same week, then "0", if not, then the number of DAYS between the two dates.&nbsp; &nbsp;Due Date is connected to my date table.&nbsp;&nbsp;
&nbsp;
I have two dates for this that are relevant.&nbsp; &nbsp; Due Date&nbsp; &nbsp;&amp;&nbsp; &nbsp;Projected Date
&nbsp;
My current code only looks at if the dates are exactly the same.&nbsp; &nbsp;What I need is to determine whether they are just in the same Week or not.&nbsp; &nbsp; &nbsp;In the example below, March 01&nbsp; and&nbsp; March 03 are within the same week, so the result should be "Yes".&nbsp;&nbsp;
&nbsp;

Is in same Week = 
VAR _DueDateWeek = SalesOrdersALL[Due Date]
VAR _ProjectedWeek = SalesOrdersALL[ProjectedDate].[Date]

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

&nbsp;

anonymous · Accepted Answer

Hi&nbsp;Anonymous&nbsp;
&nbsp;
Are you doing a DAX Calculated column or measure? Use&nbsp;WEEKNUM?

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

Forum Discussion

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

2 Replies

Related content

Different schema into different destination

Page Level filter for different groups

Difference between different Staging lakehouses

Dynamic Calculation Different Period

Date Different return wrong value