topic Re: Get the second tuesday of the next Month from today in DAX Commands and Tips

Get the second tuesday of the next Month from today

Neandril — Fri, 13 Jan 2023 13:17:08 GMT

Hello.

I want to retrieve the next second tuesday of the next month from today. How can I achieve this in DAX please ?

For example, next 2nd tuesday is the 14th on February.

Thank's in advance

Re: Get the second tuesday of the next Month from today

amitchandak — Fri, 13 Jan 2023 13:36:28 GMT

Neandril , Create a new column or measure as per need

New =var _nx = EOMONTH(TODAY(),0)+1 return _nx -WEEKDAY(_nx,2) +16

Re: Get the second tuesday of the next Month from today

Neandril — Fri, 13 Jan 2023 14:00:24 GMT

Thank's for this.

However, it "partially" works. On some months, it returns incorrect values (I created a calendar table for test purpose). Last November, it should be the 8th, but this formula returns the 15th.

Re: Get the second tuesday of the next Month from today

Anonymous — Mon, 16 Jan 2023 06:03:39 GMT

Hi Neandril ,

Here I suggest you to try this code to create a calculated column or a measure.

New = VAR _NextMonthFirstDay = EOMONTH ( TODAY (), 0 ) + 1 VAR _WeekdayOfFirstDay = WEEKDAY ( _NextMonthFirstDay, 2 ) RETURN IF ( _WeekdayOfFirstDay > 2, _NextMonthFirstDay - _WeekdayOfFirstDay + 16, _NextMonthFirstDay - _WeekdayOfFirstDay + 9 )

Here I have a test on a Date table, it works.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.