Forum Discussion
Percent Complete from dates
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.
Yes sir. See link below. Look at Table "ScheduleJan21"
amitchandak Maybe this is simpler to understand what i am trying to do. Thanks!
