Countrows dates after today <6 months

[AMBP1973]

Hello, 

I am looking for DAX to Countrows of a date column to show a result of number of dates between today and the next 6 months.

Any assistance is greatly appreciated. 🙂

[vicky_ · Accepted solution]

Try the following formula: 

Measure = COUNTROWS(CALCULATETABLE('Table', DATESINPERIOD('Table'[Dates], TODAY(), 6, MONTH)))

[AMBP1973]

Thankyou, much appreciated 🙂