cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

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
Highlighted
Microsoft
Microsoft

Re: multiple queries for SPC data

Hi @Anonymous,

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.

View solution in original post

4 REPLIES 4
Highlighted
Super User IX
Super User IX

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


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




Highlighted
Anonymous
Not applicable

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
Highlighted
Microsoft
Microsoft

Re: multiple queries for SPC data

Hi @Anonymous,

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.

View solution in original post

Highlighted
Microsoft
Microsoft

Re: multiple queries for SPC data

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

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.

Helpful resources

Announcements
Meet the 2020 Season 2 Power BI Super Users!

Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Solution Authors
Top Kudoed Authors