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, 

[lbendlin]

You are working on a report, not a dashboard.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...