topic Re: DAX - If Today is the last Monday of the month. in DAX Commands and Tips

DAX - If Today is the last Monday of the month.

msommerf — Tue, 26 Jul 2022 08:56:30 GMT

I have the following scenario that I am hoping somebody can help with?

I have a Power BI report on which I would like to display some set text if today is the last Monday of the Month.

Is there a way I can check if Today() is the last Monday of the current month, if yes display 1 else 0?

The report does not have a date table as the data displayed does not have any dates in it.

Any assitance appreciated.

Re: DAX - If Today is the last Monday of the month.

tamerj1 — Tue, 26 Jul 2022 10:19:16 GMT

Hi msommerf

you check that using

IF ( WEEKDAY ( TODAY ( ), 2 ) = 1, 1, 0 )

Re: DAX - If Today is the last Monday of the month.

msommerf — Tue, 26 Jul 2022 10:54:56 GMT

Won't that only tell me if today is a Monday? It won't tell me if it is the last Monday of the month.

Re: DAX - If Today is the last Monday of the month.

tamerj1 — Tue, 26 Jul 2022 11:02:54 GMT

msommerf
Oh srry did not read carefully. Please try

= VAR TodayDate = TODAY () VAR StartOfTheMonth = EOMONTH ( TodayDate, -1 ) + 1 VAR EndOfTheMonth = EOMONTH ( TodayDate, 0 ) VAR T1 = CALENDAR ( StartOfTheMonth, EndOfTheMonth ) VAR T2 = ADDCOLUMNS ( T1, "@Weekday", WEEKDAY ( [Date], 2 ) ) VAR T3 = FILTER ( T2, [@Weekday] = 1 ) VAR LastMonday = MAXX ( T3, [Date] ) RETURN IF ( TodayDate = LastMonday, 1, 0 )

Re: DAX - If Today is the last Monday of the month.

msommerf — Tue, 26 Jul 2022 11:41:25 GMT

Hi tamerj1 . This is prefect and works a treat. Many thanks for your help.