Forum Discussion

js1965's avatar
js1965
Regular Visitor
3 years ago
Solved

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 completi...
Need Help
Tutorial Requests
  • olgad's avatar
    olgad
    3 years ago

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

     

olgad's avatar
olgad
Icon for Resident Rockstar rankResident Rockstar
3 years ago

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's avatar
js1965
Regular Visitor
3 years ago

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