Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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 |
---|---|
16 | |
13 | |
12 | |
11 | |
11 |
User | Count |
---|---|
19 | |
15 | |
14 | |
11 | |
10 |