Percent Complete from dates

[PabloGiraldo]

Have asked this a few times and not sure if it is possible.

Would like to create a percent complete using dates from my construction schedule to add to a card.

(today's date minus project start date) / (project finish date minus project start date)

link to pbix below. Screenshot also  shows what i am trying to do.

https://walshgroup-my.sharepoint.com/:u:/p/pgiraldoclavijo/EULCihOzBEZMtFJFyIW_DhsBV2UnsXseGlU3U9PFD... 

Thank you!

[amitchandak]

@PabloGiraldo ,

A new column

divide(datediff([start Date], today(), day), datediff([start date], [end date], day))

A new measure

AverageX(values(table[project id]), calculate(divide(datediff(min([start Date]), today(), day), datediff(min([start date]), max([end date]), day))))

[PabloGiraldo]

Thanks! Forgot to mention. The min would not work because my construction schedule starts a month or so before 8/24/2020. I already tried what you suggested but did not work in my case. Any idea how to go about this? Trying to find a way to pick a specific date from my table.

[amitchandak]

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[PabloGiraldo]

@amitchandak Maybe this is simpler to understand what i am trying to do. Thanks!

[DataZoe]

Re: Project percent complete - Microsoft Power BI Community

[PabloGiraldo]

Yes sir. See link below. Look at Table "ScheduleJan21"

https://walshgroup-my.sharepoint.com/:u:/p/pgiraldoclavijo/EULCihOzBEZMtFJFyIW_DhsBV2UnsXseGlU3U9PFD...