Forum Discussion
Dividing values from two columns with Many-to-Many relationship
I am trying to calculate productivity for the operators in my department. The values in each column are totals for the week. The input column is a sum of hours worked each day. The output column is the sum of hours based on the standard time for each order completed. The columns are populated by two different data sources. The only available option for linking these two tables was a Many-to-Many relationship. I'm just not sure how to set up a calculated column to compute the output/input ratio with this relattionship type. Any help you can give me would be greatly appreciated. If you need more information I can try to provide it to you.
3 Replies
- amitchandak
Super User
You do not have the following columns in both tables?
1. Date
2. Department
amitchandak Date and Employee ID are the only two columns these data sets have in common. They are sourced from two differernt transactions in SAP. I can not use any relationship type for either column other than many-to-many.
- amitchandak
For Date, you can create a common time dimension, which in any case you will require to get most of your analysis. That you can generate in power BI.
For Employee Id, Either you can bring master or can combine in power bi?
