Forum Discussion
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 ...
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
v-danhe-msft
Microsoft Employee
Microsoft EmployeeHi 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