Determine if dates between 2 date columns are in the calendar in Power BIi

Question

How do I determine using DAX whether the dates between 2 columns (column A and B) are within dates shown in the created calender with an If statement of yes or no for a calculated column?

Answer 1

Can you please try following DAX?

---

Check = 
IF (
    AND (
        [Date Column A] > MIN ( Sheet2[Date] ),
        [Date Column B] < MAX ( Sheet2[Date] )
    ),
    "Yes",
    "No"
)

---

Sample data Table 1 Sample Calendar Table

Output Snippet

I hope I was able to answer your questions. Cheers.