Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Having 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.
@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.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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 |
I unpivoted the data, that is working great for giving me the data that i need by Employee. I think i need to input another table with the same data as a secondary source now though. After unpivoting the data, my other numbers were ballooned due to creating a new row for each EMP column.
@TaylorLowrey you need to unpivot your data then it all will be very easy. You can unpivot data very easily in power query.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |