Standard deviation in Power BI

[Anonymous]

Hi Experts

Need help to work out the Standard deviation of the following data set as shown below

The excel formula is = STDEVPA(Range) of the below data

the Answer is 5.6% of the below numbers

My Measure is

STD = 
Calculate(STDEV.P(Llo_Data[Net Amt %]), Allexcept(Llo_Data,Llo_Data[Date]))

not getting even close with the above measure.

[Mohammad_Refaei]

@Anonymous the syntax you wrote is correct and it is producing the same value as your Excel workbook.

Please check this sample file

You may take a look at the relationships.

[aj1973]

Hi @Anonymous 

Could it be because you are using a filter "ALLEXCEPT"!! Try without it.

STD = STDEV.P(Llo_Data[Net Amt %])

[Anonymous]

Hi Amine - Nope - thanks for the feedback not correct. not getting STD = 5.6%

[aj1973 · Accepted solution]

Same result without ALLEXCEPT

Some transformation might need to be applied on your Excel file.

[Mohammad_Refaei]

Yes... the syntax is not the issue. There's another underlying reason.

[aj1973]

Hey how about you share a file with us, can't keep speculating on what's wrong...

But try STEDV.S first instead of P

[Anonymous]

Thanks for the feedback and apologies for not sharing a file (PBIX). 

[aj1973]

Welcome