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

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?

Solution 1:^[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.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	ouflak

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

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]