Calculated column IF Dates Between DAX

[Anonymous]

Hi Experts

Need a calculated column measure to return 1 if the Closk Start Date is between the SubmissionStartDate and SubmissionEndDate...

Clock Start Date                 SubmissionStartDate                          SubmissionEndDate

02/08/2022                         01/08/2022                                        31/08/2022

New Column return either 1 or 0, in this case it lies between the two dates

[PVO3 · Accepted solution]

I think you are looking for a calculated column like:

Column =

IF(

  Start Date > SubmissionStartDate && Start Date < SubmissionEndDate ||

  Start Date < SubmissionStartDate && Start Date > SubmissionEndDate,

  1,

  0

)

[Anonymous]

stop on sir