Hi, please help, I'm struggling to wrap my head around the measure that should be created. I can easily do this for a static table but would like the table to be dynamic. I am creating a x bar s bar control chart.
I have created a pivot table based on power query. The original table has a column called 'Value'. When creating the pivot table I added 'Value' and the data is sliced by 'Injection Date and Time' and the values are summarized by average to get x bar [per Inject Date/Time]. I added 'Value' again and summarized by STD DEV to get StdDev [per Inject Date/Time].
x double bar is the average of 'Value'. I created this as a calculated column in power pivot by averaging 'Value'.
(I know x bar is correct because when I manually check the data by averaging the x bar values I get the x double bar value calculated in the power pivot)
Now the part I am struggling with is to average StdDev [per Inject Date/Time] in the pivot table to get s bar [Calculate average of STD DEV if Injection date and time is equal]
Table Name = ICPOES
There is a calendar table and there is a relationship between 'Date' in the calendar table and 'Batch Date' in the ICPOES table
There are always 15 'Value' with same Injection Date and Time (i.e. subgroup, n = 15)
Any assistance on how to calculate s bar using power pivot?
I have created a pivot table based on power query. The original table has a column called 'Value'. When creating the pivot table I added 'Value' and the data is sliced by 'Injection Date and Time' and the values are summarized by average to get x bar [per Inject Date/Time]. I added 'Value' again and summarized by STD DEV to get StdDev [per Inject Date/Time].
x double bar is the average of 'Value'. I created this as a calculated column in power pivot by averaging 'Value'.
(I know x bar is correct because when I manually check the data by averaging the x bar values I get the x double bar value calculated in the power pivot)
Now the part I am struggling with is to average StdDev [per Inject Date/Time] in the pivot table to get s bar [Calculate average of STD DEV if Injection date and time is equal]
Table Name = ICPOES
There is a calendar table and there is a relationship between 'Date' in the calendar table and 'Batch Date' in the ICPOES table
There are always 15 'Value' with same Injection Date and Time (i.e. subgroup, n = 15)
Any assistance on how to calculate s bar using power pivot?