Current Phase

[Razaning]

Hey y'all! 

I'm currently working on a dashboard and i need support on this requirement.

The data i have structured as follows: 

Project id, project name, phase, start date, end date. 

And the project phases are planned till 2031. 

The requirement is to have a bar chart that will calculate how many project are currently on what phase. 

I thought of using a dax return the max start date and grouped by project id. But maybe i'll need to filter it to be < todays date?

I'm not really sure.

Can you please support me in this.

Thank you in advance, 

[olgad]

Start date <=today() && enddate>=today()