Forum Discussion

chicagolarsons's avatar
chicagolarsons
Frequent Visitor
2 years ago
Solved

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

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 h...
Need Help
  • chicagolarsons's avatar
    chicagolarsons
    2 years ago

    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))
chicagolarsons's avatar
chicagolarsons
Frequent Visitor
2 years ago

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