Forum Discussion
Unable to create multiple relationships to one field
I have a table of data that has multiple employee name columns. The other data columns apply to each employee column individually for tracking purposes. Sample table looks something like.. Emp1. E...
TheOckieMofo
Resolver II
Resolver IIHaving 3 employee columns doesn't seem to make sense to me here. Sounds to me like you need to un-pivot the data via power query then the measures would be very simple. Unless you really need to delineate whether the employee in question was coded as emp1, emp2, or emp3.
- The reason for the employee columns is merely how the data is collected at the source. Essentially multiple employees work together on a line, data is recorded at one instance and assigns the employees that are currently on the line into employee name columns.
I guess ill do some reading on un pivoting data- parry2k
Super User
TaylorLowrey it is fine you are getting the dta the way it is but unpivot will work, post sample data here and I will get you the solution.
Start Date End Date Submission Number Export App Name Username User Last Name User First Name Response ID Response Date/Time Device Date/Time Submission Form Name Submission Form Version Shift Emp 1 Emp 2 Emp 3 Room Product Type # of Lots Lot Number Product Code Product Description Lot Number2 Product Code (#2) Product Description (#2) TimeIn1 TimeOut1 TimeIn2 TimeOut2 TimeIn3 TimeOut3 TimeIn4 TimeOut4 Items Weighed Items in Lot #1 Items in Lot #2 Total Time Items In Blend Min/Item 4/15/2019 12:00:00 AM 4/17/2019 11:59:59 PM 00001 Weighing xx Employee Production 4529bc7c-800a-4525-a09e-5238fbda77e6 04/15/2019 20:20:57 04/15/2019 20:19:44 Weighing 2 1 EMP 85 EMP 82 Weigh Room 1 Tablet Double Lot 8 5 5 188 10 23.5 4/15/2019 12:00:00 AM 4/17/2019 11:59:59 PM 00002 Weighing xx Employee Production 1f03669b-8315-469d-a33e-179f476f54b7 04/15/2019 23:16:52 04/15/2019 23:15:38 Weighing 2 2 EMP 99 EMP 84 Weigh Room 1 Capsule Single Lot 31 3 31
