multiple queries for SPC data

[Anonymous]

  I am pulling measurements in from an SPC system at my company but the data is coming in through 2 different queries called specs and data. The specs table has all a field called "type" and has the name of all of different measurements the personnel take (height, weight, width, etc.) as well as the upper spec limit (USL) and lower spec limit (LSL). The data query has individual columns with all of the measurements. Is there a relationship I can make between the two queries so that when someone wants to pull the measurements for a "type", it will pull the same "type" measurements from the data query?

[v-danhe-msft]

Hi @Anonymous ,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

Regards,

Daniel He

[Greg_Deckler]

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

[Anonymous]

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

[v-danhe-msft · Accepted solution]

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