Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Project SChedule Completion %

Hello,   This is my first time posting to the boards, so I hope i've followed the etiquettes.    I am trying to calculate schedule % completion for a list of projects that spans over the years. I...
Need Help
  • collinq's avatar
    collinq
    6 years ago

    Anonymous ,

     

    Yes - a separate table with that information will be able to help you get there!

  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    6 years ago

    Hi Anonymous ,

     

    Is the profect # in slicer Select project a column in 'Start & End Dates' table? If not, please check the relationship between your table.

     

    And you can try this calculate column and measure, maybe it is helpful.

     

    Schedule Completion column = 
var monthsgone = 'Start & End Dates'[Today]-'Start & End Dates'[Start Date]
var monthsremaining = 'Start & End Dates'[End Date] - 'Start & End Dates'[Start Date]
var completed = DIVIDE(monthsgone,monthsremaining)
return
IF(completed>=1,1,completed)

     

    Schedule Completion measure = 
var monthsgone = MAX('Start & End Dates'[Today])-MAX('Start & End Dates'[Start Date])
var monthsremaining = MAX('Start & End Dates'[End Date]) - MAX('Start & End Dates'[Start Date])
var completed = DIVIDE(monthsgone,monthsremaining)
return
IF(completed>=1,1,completed)

     

     

     

    If it doesn’t meet your requirement, could you please provide a mockup sample based on fake data or describe the fields of each tables and the relations between tables simply?

    It will be helpful if you can show us the exact expected result based on the tables.

     

    Please upload your files to OneDrive For Business and share the link here. Please don't contain any Confidential Information or Real data in your reply.

     

    BTW, pbix as attached.

     

    Best regards,

     

    Community Support Team _ zhenbw

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

v-zhenbw-msft's avatar
v-zhenbw-msft
Community Support
6 years ago

Hi Anonymous ,

 

Is the profect # in slicer Select project a column in 'Start & End Dates' table? If not, please check the relationship between your table.

 

And you can try this calculate column and measure, maybe it is helpful.

 

Schedule Completion column = 
var monthsgone = 'Start & End Dates'[Today]-'Start & End Dates'[Start Date]
var monthsremaining = 'Start & End Dates'[End Date] - 'Start & End Dates'[Start Date]
var completed = DIVIDE(monthsgone,monthsremaining)
return
IF(completed>=1,1,completed)

 

Schedule Completion measure = 
var monthsgone = MAX('Start & End Dates'[Today])-MAX('Start & End Dates'[Start Date])
var monthsremaining = MAX('Start & End Dates'[End Date]) - MAX('Start & End Dates'[Start Date])
var completed = DIVIDE(monthsgone,monthsremaining)
return
IF(completed>=1,1,completed)

 

 

 

If it doesn’t meet your requirement, could you please provide a mockup sample based on fake data or describe the fields of each tables and the relations between tables simply?

It will be helpful if you can show us the exact expected result based on the tables.

 

Please upload your files to OneDrive For Business and share the link here. Please don't contain any Confidential Information or Real data in your reply.

 

BTW, pbix as attached.

 

Best regards,

 

Community Support Team _ zhenbw

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

collinq v-zhenbw-msft ,

 

I am really close to the solution. The measure I created is not filtered when I select a project. Although, the column I had created for schedule completion works but it's a column and won't show in a card. 

The dax used for both are the same except one gives a column and other gives a measure. I am not sure why the measure isn't reading the project# filter.