Get the second tuesday of the next Month from today

[Neandril]

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

[amitchandak]

@Neandril , Create a new column or measure as per need

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

[Neandril]

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.

[Anonymous · Accepted solution]

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.