Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
)
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
25 | |
20 | |
18 | |
18 | |
15 |
User | Count |
---|---|
38 | |
20 | |
19 | |
16 | |
10 |