Forum Discussion
Percent Complete from dates
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.
Thank you!
6 Replies
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))))
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.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
