Monday before 3rd Saturday in Calendar

[yogeshk77]

I have a Calendar Table created in DAX
I have Calculated Column that says "True" for the date if it's the 3rd Saturday in that month, False otherwise

Now, I need another column called "Is My Monday" that should have "True" if that date is the Monday before the Third Saturday, "False" otherwise like this ->

How do I write a DAX expression for such a calculated column?

[johnt75 · Accepted solution]

I think you can create a column like

Is My Monday =
IF (
    WEEKDAY ( 'Date'[Date], 2 ) = 1,
    VAR CurrentDate = 'Date'[Date]
    VAR IsThirdSat =
        LOOKUPVALUE ( 'Date'[Is Third Saturday], 'Date'[Date], CurrentDate + 5 )
    RETURN
        IF ( IsThirdSat, 1, 0 ),
    0
)