cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
deisd11 Frequent Visitor
Frequent Visitor

multiple queries for SPC data

  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?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: multiple queries for SPC data

Hi @deisd11,

Based on my test, you could refer to below steps:

Unpivot your 'Height', 'weight' and 'width‘ column:

1.PNG

Apply it and create relationships between two tbales:

1.PNG

Now you could see the result:

1.PNG

You could also download the pbix file to have a view.

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Super User
Super User

Re: multiple queries for SPC data

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


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


deisd11 Frequent Visitor
Frequent Visitor

Re: multiple queries for SPC data

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 DescriptionVariableTargetUSLLSL
76AHeight10119
76AWeight100100.599.2
76AWidth44.33.7
86AHeight9108
86AWeight606556
86AWidth33.42.8

 

 

Data
DateTimeToy DescriptionHeightWeightWidth
1/19/201913:4576A10.2100.74.1
2/1/20191:4576A10.110103.7
2/10/20194:4586A9.3623
Community Support Team
Community Support Team

Re: multiple queries for SPC data

Hi @deisd11,

Based on my test, you could refer to below steps:

Unpivot your 'Height', 'weight' and 'width‘ column:

1.PNG

Apply it and create relationships between two tbales:

1.PNG

Now you could see the result:

1.PNG

You could also download the pbix file to have a view.

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: multiple queries for SPC data

Hi @deisd11 ,


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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.