Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
Solved! Go to 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
)
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
)
User | Count |
---|---|
21 | |
20 | |
14 | |
10 | |
8 |
User | Count |
---|---|
30 | |
28 | |
14 | |
13 | |
11 |