topic Re: Count orders with ETA day 1 to16 next month in DAX Commands and Tips

Count orders with ETA day 1 to16 next month

UlrikL — Fri, 04 Dec 2020 13:37:07 GMT

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

)

)

)

Re: Count orders with ETA day 1 to16 next month

wdx223_Daniel — Fri, 04 Dec 2020 16:42:48 GMT

C5 - Orderbank 1-16 Next Mth =

CALCULATE(

[1 - CC]

,DateType[DateType_Name] = "ETA Date"

,DATESINPERIOD(

'Date'[Date]

,EOMONTH(TODAY(),0)+1

,16

,DAY

)

)

Re: Count orders with ETA day 1 to16 next month

UlrikL — Mon, 07 Dec 2020 07:55:53 GMT

Thanx 😊