Average of open and closed periods

[tomperro]

What is the best way to get an overall combined average of percent complete for different target types and open and closed periods?

I have annual employee targets that are employees have the entire year to complete.  
Quarterly targets that are due each quarter and monthly targets due by the end of each month.

I am able to get a percentage complete for each target type, but what is the formula to combine each percent complete, giving more "weight" to target periods that are over.

for example, using April 15th as my date:

annual target is open and 10% complete

quarter target is open 5% complete

montly target is open 10%complete

percent year complete: 35%

percent quart complete: 10%
gow would I roll these into an overall percent complete?

Percent month complete: 

[v-echaithra]

Hi @tomperro ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,
Chaithra E.

[v-priyankata]

Hi @tomperro 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[Greg_Deckler · Accepted solution]

@tomperro Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.