Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
yogeshk77
Helper I
Helper I

Monday before 3rd Saturday in Calendar

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

 

yogeshk77_0-1676038367009.png

 

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 ->

yogeshk77_1-1676038536800.png

 

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

1 ACCEPTED SOLUTION
johnt75
Super User
Super User

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
)

View solution in original post

1 REPLY 1
johnt75
Super User
Super User

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
)

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.