Standard Deviation of multiple values same dates

[Anonymous]

Hi Experts

See attached sample data. I am trying to work out the std dev - the value in the card in the sample file is wrong ANSWER is 2.1%

I need to workout the Std dev of the data in the table..

Sample file.

https://www.dropbox.com/s/pnl9cvjp0tm3xkg/standard%20deviation.pbix?dl=0 

[mahoneypat]

How did you calculate 2.1% for this data set?  3.65% looks correct.

Pat

[Anonymous]

in excel i have = Stdevpa(040:o41) where the i have 37%,34% in column A cell A1,A2 and this give me 1.6% APOLOGIES. should be 1.6%.

[mahoneypat · Accepted solution]

I see what you are doing now.  This measure will give you the standard deviation of the sum of net amt for each Date.  This version give 1.5%.  The .S version gives 2.1%.

Standard Deviation =
STDEVX.P (
    DISTINCT ( 'STD Dev'[Date] ),
    CALCULATE ( SUM ( 'STD Dev'[Net Amt %] ) )
)

Pat

[Anonymous]

Thank you sir. Let me test the measure