Calculate Standard Deviation on columns

[Medmbchr]

Hi

I have a table with 13 columns: SKU ID and consumptions over 12 months, each month in a column.

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.

How can I calculate standard deviation on multiple columns instead of one?

Thanks

[mh2587]

yeah with UNION() and SelectColumn() combination
referring you to this article 

https://stackoverflow.com/questions/50213905/is-it-possible-to-unpivot-in-power-bi-using-dax

[mh2587]

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

[Medmbchr]

Hi

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]

if possible Unpivote these columns into single column 

[Medmbchr]

Is unpivot possible with DAX?