Forum Discussion
multiple queries for SPC data
Hi Anonymous,
Based on my test, you could refer to below steps:
Unpivot your 'Height', 'weight' and 'width‘ column:
Apply it and create relationships between two tbales:
Now you could see the result:
You could also download the pbix file to have a view.
Regards,
Daniel He
Tough to visualize. Sample/example data would make it much more clear. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
So this is essentially how the information looks. I'm looking for a relationship to tie together the "Variable" tab fromt the spec table and the correct variable column from the data table.
Specs Toy Description Variable Target USL LSL 76A Height 10 11 9 76A Weight 100 100.5 99.2 76A Width 4 4.3 3.7 86A Height 9 10 8 86A Weight 60 65 56 86A Width 3 3.4 2.8 Data Date Time Toy Description Height Weight Width 1/19/2019 13:45 76A 10.2 100.7 4.1 2/1/2019 1:45 76A 10.1 1010 3.7 2/10/2019 4:45 86A 9.3 62 3 Hi Anonymous,
Based on my test, you could refer to below steps:
Unpivot your 'Height', 'weight' and 'width‘ column:
Apply it and create relationships between two tbales:
Now you could see the result:
You could also download the pbix file to have a view.
Regards,
Daniel He