Forum Discussion
Calculating Percentage time remaining
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 🙂
Super UserAnonymous
What is your expected results ? Can you show it for one code?
Can you try this :
m =
SUMX('TableA',
DIVIDE(
'TableA'[Remaining Days],
'TableA'[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 🙂
Hi Fowmy
This is the results I get:
| code | Start Date | End date | Project No of days | This is what it should be ::Remaining Days | The resulst I want ::Time remaining % | New Measure |
| ABC | 05/09/2016 | 04/08/2020 | 1429 | -20 | -1% | -5% |
| ZZZ | 01/05/2008 | 31/12/2008 | 244 | -4254 | -1743% | -15752% |
| AAA | 01/12/2019 | 30/11/2020 | 365 | 98 | 27% | 27% |
| EFG | 01/07/2018 | 30/12/2020 | 913 | 128 | 14% | 127% |
The colums in Green is what I am tryign to acheive.
The column in Blue is what I am am trying to acheive.
The column in Red is the new measure, its getting there slowly.
I made sure all the values come from the same table, trying to remove an filter context. I may need to rethink my how I am doing calculations, these are based around todays date.
Alos even though not inlustrated, onthe source tabel theerare several rows for ABC, ZZ etc, here I am just showing one line for simplicity.
Project No of Days = start date-end date
Remaining Days = End Date - Today()
% Time Remaining Measure = Remaining Days / Project No of Days
Chris
- Fowmy
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