Calculate Standard Deviation on columns

Question

Hi&nbsp;I have a table with 13 columns: SKU ID and consumptions over 12 months, each month in a column.&nbsp;I am struggling to calculate standard deviation of the 12 months, I found no DAX formula except STDEV.P which needs all values in one column, I want to use SUMMARIZE but my case is too complicated since I need to calculate a "dynamic" standard deviation based on my review periods.&nbsp;How can I calculate standard deviation on multiple columns instead of one?&nbsp;Thanks

mh2587 · Answer

Check the details of these functions might be helpful&nbsp;STDEVX.S&nbsp;、STDEVX.P、&nbsp;STDEV.P、STDEV.S

medmbchr · Answer

Hi&nbsp;As I said, these formulas need all data to be in one column, while I have my values spread over 12 columns.I need another way.

mh2587 · Answer

if possible Unpivote these columns into single column&nbsp;

medmbchr · Answer

Is unpivot possible with DAX?

mh2587 · Answer

yeah with UNION() and SelectColumn() combinationreferring you to this article&nbsp;
https://stackoverflow.com/questions/50213905/is-it-possible-to-unpivot-in-power-bi-using-dax

Forum Discussion

Calculate Standard Deviation on columns

5 Replies

Related content

Standard Deviation

Calculating a Weighted Standard Deviation

Standard Deviation DAX

Calculate Standard deviation from a measure

Standard Deviation of total sales