View Item Completion Percentages Month to Month

[js1965]

Hello All,

I am of course new to this forum and new to PowerBi.  I thank you all for patience and help before, I of course, ask for help.

Ultimately my goal is review Monthly Work Order completion percentages for only those Work Orders opened or “ Reported that month” and subsequently closed or “Finished “ that same month.

Some by by products are:

Work Orders created each month based on “Report Date”.

Work Orders completed each month based on “Actual Finish” Date.

What is the best way to approach this?

I have a sample data set below:

Work Order Number	Report Date	Actual Finish
21-454714	10/22/2021	11/1/2021
21-454759	10/22/2021	11/1/2021
21-461753	10/28/2021	11/3/2021
21-461762	10/28/2021	11/4/2021
21-461764	10/28/2021	11/2/2021
21-461766	10/28/2021	11/2/2021
21-461768	10/28/2021	11/2/2021
21-461770	10/28/2021	11/4/2021
21-461772	10/28/2021	11/3/2021
21-461816	10/28/2021	11/2/2021
21-470561	11/5/2021	11/12/2021
21-470565	11/5/2021	11/12/2021
21-470567	11/5/2021	11/10/2021
21-470569	11/5/2021	11/9/2021
21-470571	11/5/2021	11/9/2021
21-470575	11/5/2021	11/9/2021
21-470579	11/5/2021	11/12/2021
21-470583	11/5/2021	11/10/2021
21-470585	11/5/2021	11/10/2021

[olgad · Accepted solution]

Hi, 
in Power Query add the custom column 

if Date.StartOfMonth([Report Date])=Date.StartOfMonth([Actual Finish]) then 1 else 0

That will tell you which projects were opened and closed in the same month. 

then, create DAX

% = Divide(Sum(WorkOrder[samemonth]), Count(WorkOrder[Work Order Number]))

[js1965]

THANKS!...I was so lost in the weeds. Thanks for the quick response.