Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.