cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sharksguts Regular Visitor
Regular Visitor

Labour Efficiency

How can you calculate the labour efficiency from a table of labour bookings? See example data and required results below.

 

The problem I am having is the production standard is per Job Num/Asm/Operation and there is more than one labour booking per operation,

 

Job NumAsm SeqOp SeqOp CodeProduction StdLabour HrsRequired QtyCompleted Qty
1000101070000.50.341
1000111060110.80.766
10001210601121.888
1000101070000.50.443
1000102075002142
1000102075002142

 

Expected results:  Efficiency = Production Std / Labour Hrs

 

Job NumAsm SeqOperationOp CodeProduction StdLabour HrsCompleted QtyEfficiency
1000101070000.50.7471%
100010207500224100%
1000111060110.80.76114%
10001210601121.88111%
    5.35.2 102%

 

Have tried many different ways but been unsuccessful, not sure what would be the correct way.

 

Many thanks for any pointers.

 

Regards

 

Richard

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: Labour Efficiency

@Sharksguts,

 

You may add the following measures.

Measure Production Std =
SUMX (
    SUMMARIZE (
        Table1,
        Table1[Job Num],
        Table1[Asm Seq],
        Table1[Op Seq],
        Table1[Op Code]
    ),
    CALCULATE ( MAX ( Table1[Production Std] ) )
)
Measure Labour Hrs =
SUM ( Table1[Labour Hrs] )
Measure Efficiency =
DIVIDE ( [Measure Production Std], [Measure Labour Hrs] )
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
ssugar Member
Member

Re: Labour Efficiency

 

Go to the Query Editor, select the Job Num, Asm Seq, Op Seq, and Op Code columns, and hit the Group By button.

Then in the Aggregations area use the following columns and operations:
Production Std - Min
Labour Hours - Sum
Required Qty - Sum
Completed Qty - Sum

 

community-sol-565318.png


That will get you the table you're looking for.  Then you can just divide production std by labour hours to get your efficiency.

Let me know if you need any further help.

Highlighted
Community Support Team
Community Support Team

Re: Labour Efficiency

@Sharksguts,

 

You may add the following measures.

Measure Production Std =
SUMX (
    SUMMARIZE (
        Table1,
        Table1[Job Num],
        Table1[Asm Seq],
        Table1[Op Seq],
        Table1[Op Code]
    ),
    CALCULATE ( MAX ( Table1[Production Std] ) )
)
Measure Labour Hrs =
SUM ( Table1[Labour Hrs] )
Measure Efficiency =
DIVIDE ( [Measure Production Std], [Measure Labour Hrs] )
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sharksguts Regular Visitor
Regular Visitor

Re: Labour Efficiency

Hi SSugar

 

That definitely helped me understand Power Bi more.

 

I could group the data and that would fix my problem, however, the measure suggested below would allow me to drill down.

 

Thanks for your help.

 

Richard

Sharksguts Regular Visitor
Regular Visitor

Re: Labour Efficiency

Hi Sam

 

Brilliant that worked perfectly thank you for your prompt help.

 

I'm loving Power Bi.

 

Regards


Richard

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 111 members 1,599 guests
Please welcome our newest community members: