Count orders with ETA day 1 to16 next month

[UlrikL]

Hi

I have the measure below that counts the number of orders with ETA day 1 to 16 in the next month. This works fine most of the year but when we are in December an next mont is January (and therefor year 2021) it does not work.

How do I create a measure that are not affected på change in calender year ?

C5 - Orderbank 1-16 Next Mth =

CALCULATE(

    [1 - CC]

    ,DateType[DateType_Name] = "ETA Date"

    ,DATESBETWEEN(

        'Date'[Date]

        ,EOMONTH(TODAY(),0)+1

        ,DATE(

            YEAR(TODAY())

            ,MONTH(EOMONTH(TODAY(),0)+1)

            ,16

        )

    )

)

[UlrikL]

Thanx 😊

[wdx223_Daniel · Accepted solution]

C5 - Orderbank 1-16 Next Mth =

CALCULATE(

    [1 - CC]

    ,DateType[DateType_Name] = "ETA Date"

    ,DATESINPERIOD(

        'Date'[Date]

        ,EOMONTH(TODAY(),0)+1

        ,16

        ,DAY

        )

    )