cancel
Showing results for
Did you mean:
Regular Visitor

## View Item Completion Percentages Month to Month

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
1 ACCEPTED SOLUTION
Memorable Member

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]))

Best Stories, Interesting Cases: PowerBI Storytime Newsletter
2 REPLIES 2
Memorable Member

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]))

Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Regular Visitor

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

Announcements

#### Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

#### Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

#### Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors