Forum Discussion
Calculating Percentage time remaining
Hi I am trying to create a Measure to work out a percentage of time remaining on a project, this takes into account todays date. All the data in in a single table. The table has many rows, the ...
Anonymous
You need two measures:Remaining Days = INT(TODAY() - MAX(Project[End date]))% Remaining = DIVIDE( [Remaining Days], MAX(Project[Project No of days]) )________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply 🙂
Anonymous
You need two measures:
Remaining Days =
INT(TODAY() - MAX(Project[End date]))% Remaining =
DIVIDE(
[Remaining Days],
MAX(Project[Project No of days])
)
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply 🙂
Fowmy
Looking better thanks. I also need to calculate a % percentage through the budget but I will use the examples posted here to work that part out.
Cheers Again.
Chris