topic Re: Standard deviation of population in columns in DAX Commands and Tips

Standard deviation of population in columns

Anonymous — Tue, 21 Dec 2021 09:29:28 GMT

Hello,

I need to calculate the standard deviation of a population made of monthly part sales (quantities). Each row gives the historic consumption (from 1 month in the past - Cons_1Month - to 12 months in the past - Cons_12Months ) of a part number - ITEMID.

I need the std.dev, for every rows (each p/n), of the population made of columns "Cons_1Month" to "Cons_12Months"

I prefer not to transpose as I have several other pieces of information I need to keep for each PN.

I found only ways to calculate std.dev per columns. Any idea ?

Thank you !

Re: Standard deviation of population in columns

ValtteriN — Tue, 21 Dec 2021 10:41:22 GMT

Hi,

You could do the unpivot operation to a calculated table and use that new table with RELATED to calculate standard deviation to your original table.

Example DAX (add ID to its own column in the UNION):

coltable = UNION(

SELECTCOLUMNS('STDEV',"col",[1]),

SELECTCOLUMNS('STDEV',"col",[2]),

SELECTCOLUMNS('STDEV',"col",[3]),

SELECTCOLUMNS('STDEV',"col",[4]),

SELECTCOLUMNS('STDEV',"col",[5]),

SELECTCOLUMNS('STDEV',"col",[6]),

SELECTCOLUMNS('STDEV',"col",[7]),

SELECTCOLUMNS('STDEV',"col",[8]),

SELECTCOLUMNS('STDEV',"col",[9]),

SELECTCOLUMNS('STDEV',"col",[10]),

SELECTCOLUMNS('STDEV',"col",[11]),

SELECTCOLUMNS('STDEV',"col",[12]))

I hope this helps!

Re: Standard deviation of population in columns

v-zhangti — Fri, 24 Dec 2021 08:32:13 GMT

Hi, Anonymous

If the following methods didn't solve your problem. Can you provide a PBIX file that is available for testing? What do you expect the results to look like that can be shown in an example Excel chart. I look forward to hearing from you.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.