Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 ...
  • Fowmy's avatar
    Fowmy
    6 years ago

    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 🙂

    YouTube, LinkedIn

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , Try like 

avergageX(summarize(Table, Table[code],Table[StartDate],Table[endDate],"_1", max(Table[project no of Days]), "_2",max(Table[remaining Days])), divide([_2],[_1]))