Forum Discussion
Standard Deviation Population - Power Pivot (By Group) Measure
Try using stdevx.s (evaluate for a sample population, not the entire population), and making your column reference fully qualified, which is a best practice. This means when referencing columns by name, you should include the table with it; when you reference a measure, do not include a table name.
stdevx.s('Week 3', 'Week 3'[Average])
Hi! Basically the table pictured above was from two tables that I loaded in power query. I created the lookup column in Power Query by joining the location and day of week column.
The pivot measure I tried created was calculating the Standard Deviation (Population) from the Averages column (fact table). Hope this makes sense?
Okay, so if you are using a column in your measure (as opposed to another measure) and you want the value returned for a group of the population, then try using STDEV.S. If you want the standard deviation of the actual sales amount, use the actual sales amount column - otherwise you will be getting the standard deviation of the average amounts.
STDEV.S - use a column, return the value for a sample population
STDEV.P - use a column, return the value for the entire population
STDEVX.S - use a measure or expression, return the value for a sample population
STDEVX.P - use a measure or expression, return the value for the entire population