Forum Discussion
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...
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 🙂
Fowmy
Super User
Super UserAnonymous
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 🙂
Thanks. It worked.
Could you explain me why you had to create a calender table?
Thank you,
Varsha