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.

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

Wharfey , Welcome to Power BI Community!

 

You want something like below Screen shot? if yes so use the below Measure and set it data format to %.

Task Completed = Sum('Table'[Day])/CALCULATE(sum('Table'[Day]),ALL('Table'[Day]))
 
 
Please don't forget to hit THUMBS UP and Accept this as a solution if it helps you!
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.