Forum Discussion

Wharfey's avatar
Wharfey
Frequent Visitor
6 years ago
Solved

Project Management Report - Task Completion

Hi All,   Go easy, this is my first ever post!   I need to be able to calculated expected task completion percentage based on TODAY. Eg on Day 3 of a 10 day task, it should be 30% complete in the...
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Wharfey ,

     

    You can create column like DAX below.

     

    expected_completion %=DIVIDE(DATEDIFF( [start_date], TODAY(), DAY), DATEDIFF( [start_date], [finish_date], DAY))

     

    Best Regards,

    Amy

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Wharfey's avatar
Wharfey
Frequent Visitor
6 years ago

Hi Tahreem

 

This is the kind of table view I'm after (below) so essentially all I need is a formula to calculate column E based on the TODAY() function that counts back to the start date and calculates what the percentage completion should be as of the current date. I will then use DAX to determine the Task_Health rating.

 

 

thanks again.

 
 
 
v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi Wharfey ,

 

You can create column like DAX below.

 

expected_completion %=DIVIDE(DATEDIFF( [start_date], TODAY(), DAY), DATEDIFF( [start_date], [finish_date], DAY))

 

Best Regards,

Amy

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.