Calculated column IF Dates Between DAX

Question

Hi Experts&nbsp;Need a calculated column measure to return 1 if the Closk Start Date is between the SubmissionStartDate and SubmissionEndDate...Clock Start Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SubmissionStartDate&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;SubmissionEndDate02/08/2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/08/2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 31/08/2022&nbsp;New Column return either 1 or 0, in this case it lies between the two dates

pvo3 · Accepted Answer

I think you are looking for a calculated column like:
Column =
IF(
&nbsp;&nbsp;Start Date &gt;&nbsp;SubmissionStartDate&nbsp;&amp;&amp;&nbsp;Start Date &lt;&nbsp;SubmissionEndDate ||
&nbsp;&nbsp;Start Date &lt; SubmissionStartDate&nbsp;&amp;&amp;&nbsp;Start Date &gt; SubmissionEndDate,
&nbsp; 1,
&nbsp; 0
)

Forum Discussion

Calculated column IF Dates Between DAX

2 Replies

Related content

TMDL - calculated column

Direct Lake Model - Calculated Column/Tables

Power Query or Calculated columns

IF calculated column

Dynamic Variable in Calculated Columns