Dax Measure: How Many Projects Starting in Next 30 Days?

[chicagolarsons]

Hi, 

I have written a measure to count how many projects start in the next 30 days, but it is not working and I'm hoping someone here can help me troubleshoot. As you can see in the table below, I have a list of projects, along with their start dates (mobilization).  My client would like to keep track of how many projects are mobilizing in the next 30, 60, 90, and 120 days. The measure I've written indicates there are no projects starting in the next 30 days, but lines 3 and 4 on the table below ARE starting in the next 30 days and should therefore have been counted. 

Here is the measure I've written:

ConStart+30 = CALCULATE(COUNTROWS('Project Tasks'), FILTER('Project Tasks', [Task Name]="Mobilization"), DATESINPERIOD('Calendar'[Dates], TODAY(), 30, day))

And here is the screenshot:

Thanks in advance for any help offered!

Kirstin

[chicagolarsons · Accepted solution]

I figured this out on my own, but will post the solution in case it helps others:

ConStart+30 = CALCULATE(COUNTROWS('Project Tasks'), FILTER('Project Tasks', [Task Name]="Mobilization" && [Start]>=TODAY()&&[Start]<=TODAY()+30))