Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Productivity- Pallets per man hour

Hi All,  Fairly new to Power BI,  Could some one help me with below  Table 1- where i have Month/year, Customer and Hours  Table 2- Where i have month-year, Customer and Pallets   I need to fin...
Need Help
  • Fowmy's avatar
    Fowmy
    6 years ago

    Anonymous 

    I created a calendar table linked to both tables, you measure is simple now.

    You can download the file: HERE



    Measure 5 = 
VAR _Hours= Sum(Table1[Hours])
VAR _Pallets= SUM(Table2[Total Pallets])
RETURN
DIVIDE(_Pallets,_Hours)

    ________________________

    If my answer was helpful, please consider Accept it as the solution to help the other members find it

    Click on the Thumbs-Up icon if you like this reply 🙂

    YouTube  LinkedIn

     



Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
6 years ago

Anonymous 

It is password protected

 

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    Spoiler
    Fowmy Can you check now?
    • Fowmy's avatar
      Fowmy
      Icon for Super User rankSuper User
      6 years ago

      Anonymous 

      I created a calendar table linked to both tables, you measure is simple now.

      You can download the file: HERE



      Measure 5 = 
VAR _Hours= Sum(Table1[Hours])
VAR _Pallets= SUM(Table2[Total Pallets])
RETURN
DIVIDE(_Pallets,_Hours)

      ________________________

      If my answer was helpful, please consider Accept it as the solution to help the other members find it

      Click on the Thumbs-Up icon if you like this reply 🙂

      YouTube  LinkedIn

       



      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Thanks. It worked. 

         

        Could you explain me why you had to create a calender table?

         

        Thank you, 

        Varsha