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

chicagolarsons — Fri, 28 Jun 2024 18:47:09 GMT

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

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

chicagolarsons — Fri, 28 Jun 2024 19:05:27 GMT

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))

topic Dax Measure: How Many Projects Starting in Next 30 Days? in DAX Commands and Tips

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

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