cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

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
v-danhe-msft
Microsoft
Microsoft

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.
Greg_Deckler
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Learn Power BI 2nd Edition
Anonymous
Not applicable

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

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.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors